Best Microsoft Excel Bloggers

Thursday, January 12, 2017

Date and Day Functions

Date and Day Functions

I found an interesting site on Excel for SEOs.
Actually, most of the information on the site pertains to anyone using Excel.
One of their pages was on dates and days. I find a lot of people struggle with date functions
=NOW() and =TODAY() are the most common  Date functions.
 They are called volatile functions because they change as the date changes. =NOW() is the more versatile of the two as it tracks both date and time, however, you can format it so that it displays just the date, just the time or both. Whereas, =TODAY only displays and tracks the current date.
They can be very useful. For example, if you create and print a lot of versions of a document, such as a budget. include =NOW(), at the top or in the document header. The =NOW() will display the time - you can even  format down to the second- so you are confident that you have the latest version of your document as you go off to your presentation.

This site has some other date functions that you may be interested in  - particularly NETWORKDAYS and YEARFRAC.
I hope you find them useful.

Ms. Excel- Resident Excel Geek