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.)

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.