Posted by Dave on

Datediff in Excel

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?



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

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