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