Forum Discussion

BBacon621's avatar
BBacon621
Copper Contributor
Sep 23, 2021
Solved

calculating dob for daycare list when child isn't born yet

I have a spreadsheet that calculates the DOB of a child based on todays date and DOB - what do I do if it's also a waiting list because the child isn't born yet? I get a #NUM! error. I'm thinking it ...
Formulas and Functions
  • JSHEP73's avatar
    JSHEP73
    Sep 24, 2021

    BBacon621 , just wrap your existing formula with the IFERROR formula,

     

    =IFERROR(DATEDIF(B2,TODAY(),"y")&" year(s), "&MOD(DATEDIF(B2,TODAY(),"m"),12)&" month(s)",0)

JSHEP73's avatar
JSHEP73
Brass Contributor
Sep 24, 2021

BBacon621 , just wrap your existing formula with the IFERROR formula,

 

=IFERROR(DATEDIF(B2,TODAY(),"y")&" year(s), "&MOD(DATEDIF(B2,TODAY(),"m"),12)&" month(s)",0)

BBacon621's avatar
BBacon621
Copper Contributor
Sep 24, 2021
thank you that worked!

Resources