Datediff in Excel

Another article on Excel idioms; this one’s about dates. It’ll be useful for some.

I want to create a number of frequency charts of a series of dates. Date arithmetic is notoriously hard and will rely on functions.

Here’s two ways of calculating the difference in years between a date and today, i.e. how old in years is this event?

=INT(YEAR(TODAY())-YEAR(eventdate))

=ROUNDDOWN(YEARFRAC(eventdate,TODAY(),1),0)

Featured Image:  from flickr, by Pedro Szeleky CC 2009 BY-NC-SA (This is cropped and shrunk.)

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.