| Home > Forum Home > Automating Data Analysis Tasks > Multiple If condition > Use the MONTH function | Share |
Use the MONTH function
Excel Help for Use The Month Function in Automating Data Analysis Tasks
| Forum Topic | Login |
Use The Month Function | Rate this: (3/5 from 1 vote) |
 | You could make the formula much simpler by using the MONTH function. This returns an integer from 1 to 12. You can then use the ROUNDUP function by dividing the month by 3 thereby making the formula ="Q" & ROUNDUP(MONTH(date)/3,0). | |
| Excel Business Forums Administrator | ||
| Posted by Excel Helper on | ||
| View Full Post |
| Find relevant Excel templates and add-ins for Use the MONTH function in the Excel Business Solutions Directory |