Formula to calculate participant age at time of program

Hi!

I’m trying to create a formula to calculate the age our participant (board item) was at the time they participated in our program (timeline)

Currently the formula I have is:

IF({Birthday},INT(YEARFRAC({Birthday}, {Program Date#End})),“undetermined”)

This formula works, however if the program timeline column is left blank, it generates the exclamation point error. I would like it to also say “undetermined” or “n/a” instead of the error message.

Your help is appreciated!

@mmckenna

Here you go:

IF(AND({Birthday}, {Program Date#End}), INT(YEARFRAC({Birthday}, {Program Date#End})), "undetermined")


Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: A Status Column Tip - When is “Done” really DONE?
Contact me directly here: Contact – The Monday Man

1 Like