| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying formulae changes formatting | Excel Worksheet Functions | |||
| Using the results of formulae between different spreadsheets. | Excel Worksheet Functions | |||
| Change to formulae | Excel Worksheet Functions | |||
| XL2002 Clipboard doesn't paste formulae | Excel Discussion (Misc queries) | |||
| vlookup change column index position - without changing formulae | Excel Worksheet Functions | |||
Linear Mode
