Formula - subtracting TODAY from DOB to give current age

Hi,

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.

@McKennaOMG

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

INT(YEARFRAC({DOB}, TODAY()))

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 monday.com 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?

@McKennaOMG

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

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