Are you constantly updating and changing the date on your reports? Just because time keeps going by doesn't mean that you should have to do a bunch of manual changes (or worse...forget to do them). There are several different date functions built to save you time.
TODAY: If you just need the current day's date, use the super straightforward TODAY function. Here’s an example:
By clicking fx - here and in other formulas, too - you can pull up the Function Arguments box for more detail about what the selected formula is doing. In this case, no arguments are required or even allowed.
EOMONTH: The EOMONTH function is used to calculate and present the last date of the month, like this:
Again, by clicking fx you can see the Functions Arguments available and the results. Notice that, when you select the 'Months' field, Excel displays some help to guide you with the arguments:
So what if you need the date in the title of the report combined with other text? No problem. Just combine the formulas together.
However, remember that date formulas return the serial number of the date. So you will need to nest it with a TEXT function to format it in the most readable fashion. Don't know how to do that? Give us a call or get in touch through email and we'll show you.
Leave us a comment and let readers know what Excel tips you use on a daily basis.