Tag Archives: month

XL FORMULA FOCUS: TODAY, YEAR, MONTH, DAY, DATE (an introduction to Excel date functions)

Excel Date Functions - TODAY, YEAR, MONTH, DAY & DATE
Excel Date Functions - TODAY, YEAR, MONTH, DAY & DATE

 This post will teach you five Excel functions to help you deal with dates. We will work our way through in the order that they are shown in the picture above.



=TODAY(). That’s it. That’s all you have to type, the brackets are empty. And it gives you today’s date, updating accordingly over time (whenever the worksheet recalculates). This makes it great for keeping things like age or length of service up to date.


You just point these at a cell containing a date (in the picture we use the date returned by the TODAY function). These functions then return the applicable data about that date. For example, if your date in C1 is in 2013 and you put =YEAR(C1) it will return 2013. If C1 contains a January date, =MONTH(C1) will return 1 (ie the first month of the year). And if you enter =DAY(C1) where the date is the first of a month, it returns 1 (note that this refers to the day of the months rather than the day in a week (which you can use WEEKDAY for).



So DATE works kind of like the opposite of YEAR, MONTH and DAY:
If you tried this =DATE(2013,1,1), it would give you 01/01/2012 (or 41275, the Excel serial number that represents that date). So you can see the example in the picture above goes full circle – it extracts the day, month and year from the TODAY function in cell C1, and then compiles them together again to form a date again using the DATE function.

XL FORMULA FOCUS: Find end of probation period using EDATE

So you’ve got a new employee, and you want to know when their probation period is over? The EDATE function is really straight forward.


So type in “=EDATE(“, click on the cell that contains their start date, type a comma, then enter the number of months. 3 months? 6 months? Type a 3 or a 6 or whatever it is. Then close your brackets “)” and press enter.


RELATED: If you need to calculate length of service, you may want to look here.