I want this formula to calculate the age of a child only if the Child 1 DOB field is populated. It works fine when the DOB field is populated. When blank I keep getting an invalid parameter error.
Any thoughts on how to resolve?
IF(NOT({Child 1 DOB} = “”), ROUNDUP(DAYS(TODAY(), {Child 1 DOB}) / 365, 1), “”)