Thread: date formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kathleen Kathleen is offline
external usenet poster
 
Posts: 44
Default date formulas

Hi, I have two problems that need help.

Cell A1 has a date of birth. Cell A2 calculates the age. If there isn't a
dob of birth, cell A2 returns 110.

Another one is having cell C1 with a date or NA. C2 is based on cell C1 and
adds 3 months to the date in C1 but if C1 has NA, the return is #value!.

Kathleen