formulae for dates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Gerald - 31 May 2006 09:00 GMT

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

Reply to this Message

Roger Govier - 31 May 2006 09:52 GMT

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)

Signature

Regards

Roger Govier

> below formulae
> =TODAY()-(LEFT(C1,2)*365.25)-((MID(C1,7+FIND("",MID(C1,7,99)),2))*365.25/12)
[quoted text clipped - 7 lines]
> plz advise
> thanks

Reply to this Message

Gerald - 31 May 2006 10:04 GMT

thanks

> Hi Gerald
>
[quoted text clipped - 14 lines]
> > plz advise
> > thanks

Reply to this Message