formulae for dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

below formulae
=TODAY()-(LEFT(C1,2)*365.25)-((MID(C1,7+FIND("",MID(C1,7,99)),2))*365.25/12)

gives an output is mm/dd/yy on entering 0 years x months

but if I enter 0 years 10 months or 11 months it gives me wrong date e.g if
entered 0 years 10 months it gives 31 april 2006

plz advise
thanks
 
Hi Gerald

You are missing the space between the quotes in your formula
Try
=TODAY()-(LEFT(C1,2)*365.25)-((MID(C1,7+FIND("
",MID(C1,7,99)),2))*365.25/12)
 
thanks

Roger Govier said:
Hi Gerald

You are missing the space between the quotes in your formula
Try
=TODAY()-(LEFT(C1,2)*365.25)-((MID(C1,7+FIND("
",MID(C1,7,99)),2))*365.25/12)
Click to expand...
 
Back
Top