formulae for dates

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
 
R

Roger Govier

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)
 
G

Guest

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 1 vs 10 in Excel Formula 0
Decimals on a date calculation 5
Formula Error 3
help with formula please 3
Date and Number cell formats 4
Formula to calculate elapsed dates. 2
Expiration date based on 5 years and Birth month,day ... 4
need held for auto date calculation for adding years and substract 1

Top