I am firm to make a spreadsheet that will show D.O.B. current age in days/ months/ years including number of days remaining until next birthday. Actually I am not good in remembering birthdays. I have tried but getting error like with the formula: '=DATEDIF(TODAY(),EDATE(C4,(YEAR(NOW())-YEAR(C4))*12),"d")' for '=TODAY()-C16' yields "00 Years 4 Month(s) 12 Days"
Bookmarks