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! |
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! |
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 |
All times are GMT +1. The time now is 05:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com