Excel Tip Tuesday: Using Date Formulas

Posted by Lisa on August 28, 2018 at 9:30 AM

Excel IconAre 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:

Excel Tips - Date Formulas1

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.

Excel Tips - Date Formulas2

EOMONTH: The EOMONTH function is used to calculate and present the last date of the month, like this:

Excel Tips - Date Formulas3

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:

Excel Tips - Date Formulas4

So what if you need the date in the title of the report combined with other text? No problem. Just combine the formulas together.

Excel Tips - Date Formulas5

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.

Topics: Excel

Don't Miss a Thing!

Subscribe to our blog

Subscribe to our blog

    Recent Posts