formulae for dates
 

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

formulae for dates
 

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)



--
Regards

Roger Govier


"Gerald" wrote in message
...
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

formulae for dates
 

thanks

"Roger Govier" wrote:

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)



--
Regards

Roger Govier


"Gerald" wrote in message
...
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