Days Until Next Event

Scenario:  A list contains items which have a recurring date.  Anniversary, birthday, things like that.  We want to calculate how many days remain until the next occurrence of that event.

Solution:  Create a calculated column to calculate the number of days from today until the next occurrence.  But today isn’t available in a calculated column, you say?  Bah…Head on over to Mark Kruger’s blog for a quick work around to be able to use Today in a calculation.  Cool. 

Anyway, once you do that, all you need is the calculation (DOB is my column for, well, date of birth):

This Today workaround really opens some doors that were previously closed.  Thanks Mark!

Leave a Reply

Your email address will not be published.