| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date calculation in Excel 2003
Is it possible to calculate the difference between two dates and return the
answer as yy-ddd. Thus, the difference between 1 Jan 2006 and 1 Feb 2007 would be 1-031. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date calculation in Excel 2003
Hi,
If your dates are in cell A1 and B1 : =DATEDIF(A1,B1,"Y")&" "&DATEDIF(A1,B1,"D")-365 HTH Cheers Carim |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date calculation in Excel 2003
Carim,
Your formula returns errors, as examples: A1: 31/01/2006 B1: 01/03/2008 (British style dates dd/mm/yy) Returns 2 395 A1: 31/06/2006 B1 01/03/2006 Returns 0 -366 I would suggest: =DATEDIF(A1,B1,"y")&"Years "&DATEDIF(A1,B1,"yd")& " Days" although DATEDIF() does have its own idiosyncrasies. -- Regards, Sandy In Perth, the ancient capital of Scotland with @tiscali.co.uk "Carim" wrote in message oups.com... Hi, If your dates are in cell A1 and B1 : =DATEDIF(A1,B1,"Y")&" "&DATEDIF(A1,B1,"D")-365 HTH Cheers Carim |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date calculation in Excel 2003
Sandy,
You are right ... Thanks a lot for your comments Carim |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| default manual calculation instead of auto in options excel 2003 | Excel Discussion (Misc queries) | |||
| Excel 2003 date format bug? | Excel Discussion (Misc queries) | |||
| Excel 2003: can I insert a "last edited" date function? | Excel Worksheet Functions | |||
| Date Value Funtion in Excel 2003 returns an error, but not in Exce | Excel Worksheet Functions | |||
| How do I report a Date Format bug in Excel 2003 to Microsoft ? | Excel Discussion (Misc queries) | |||
Linear Mode
