Formula - subtracting TODAY from DOB to give current age


I am trying to determine the correct formula to use to say subtract today’s date from the date in this column (DOB) to give an age.


The simplest way is to use the undocumented functions INT() & YEARFRAC():


You can find out about other undocumented functions here: The monday Hidden Functions

Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: Column Total in Formulas? YES!!!

That did the trick, thanks!

@JCorrell One more question - is there something I can add into the formula to remain blank if there is no value in DOB rather than a red exclamation point?


IF({Date},INT(YEARFRAC({Date}, TODAY())),"Who are you kidding?")

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.