Formula based on DOB column does not work

Hi everyone :raising_hand_man: ,
I work in the turrist indusrty.
I’m purchesing in advance skipasses for our customers before they arrive -
i want to determine what type of skipass i need to buy for them - baby/junior/adult - based on the DOB column.

BABY: born after 30/04/2014
JUNIOR: born between 01/05/2006 and 30/04/2014
Adult: born before 01/05/2006


This should get you started:

  IF(DATEVALUE({DOB}) < DATEVALUE("2014/4/30"),

Jim - The Monday Man
Get Custom Apps, Integrations & Automations for monday


thank you Jim it’s working :slight_smile:

1 Like