Formula based on DOB column does not work

[ARIK (Arik apl)]

Hi everyone ,
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

[JCorrell (Jim - The Monday Man)]

@ARIK

This should get you started:

IF(DATEVALUE({DOB}) < DATEVALUE("2006/5/1"),
  "Adult",
  IF(DATEVALUE({DOB}) < DATEVALUE("2014/4/30"),
    "Junior",
    "Baby"
  )
)

---

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

[ARIK (Arik apl)]

thank you Jim it’s working