Home |
Search |
Today's Posts |
#1
|
|||
|
|||
formulae
I require a formula that will count how many days between two dates.eg
23/05/02 and23/05/03. Using the rcommended formula days360(the two dates here)gives the answer 1 as in one year.........help meeeee please! |
#2
|
|||
|
|||
You want the DateDif() function.
It's undocumented, except in XL2k, so Chip Pearson has fully explained it in his web site: http://www.cpearson.com/excel/datedif.htm -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "tooks" wrote in message ... I require a formula that will count how many days between two dates.eg 23/05/02 and23/05/03. Using the rcommended formula days360(the two dates here)gives the answer 1 as in one year.........help meeeee please! |
#3
|
|||
|
|||
On Sun, 15 May 2005 16:31:02 -0700, "tooks"
wrote: I require a formula that will count how many days between two dates.eg 23/05/02 and23/05/03. Using the rcommended formula days360(the two dates here)gives the answer 1 as in one year.........help meeeee please! In Excel, dates are stored as serial numbers. So if you want the actual number of days between two dates, merely subtract one from the other. A1: 23 May 2002 A2: 23 May 2003 B1: =A2-A1 := 365 (format as General) =DAYS360(A1,A2) would give a result of 360. This formula is used for certain accounting system that assume 30 day months. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
Excel and CubeCell Formulae | Excel Discussion (Misc queries) | |||
Autofill Formulae | Excel Discussion (Misc queries) | |||
Formulae when some cells contain #N/A | Excel Discussion (Misc queries) | |||
vlookup change column index position - without changing formulae | Excel Worksheet Functions |