date differences based on 365 days

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Wanting to calculate the number of days from one date to the next based on
365 days not the 360 (12 - 30 DAYS MONTHS) WHAT HAPPEN TO THE MONTHS WITH 31
DAYS that excel 2000 offers

Example: July 24/2004 to August 31/ 2004 = (8) + (31) = 39 DAYS
 
Since there's only 31 days in July, from the 24th to the end of the month is
only 7days, right?
And with 31 days in August, you should total 38, right?

So, try this:
A1 = 7/24/04
B1 = 8/31/04
Enter in C1
=DATEDIF(A1,B1,"d")

The Datedif function is in the XL2000 help *only*.
If you are using another version, go here for an explanation:

http://www.cpearson.com/excel/datedif.htm
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Wanting to calculate the number of days from one date to the next based on
365 days not the 360 (12 - 30 DAYS MONTHS) WHAT HAPPEN TO THE MONTHS WITH 31
DAYS that excel 2000 offers

Example: July 24/2004 to August 31/ 2004 = (8) + (31) = 39 DAYS
 
Example: July 24/2004 to August 31/ 2004 = (8) + (31) = 39 DAYS
Click to expand...

Excel stores dates as a serial number, so all you have to do is subtract one
from the other. If you want to include both the starting and ending date, then
add 1.

A1: 7/24/2004
A2: 8/31/2004

Num of days = A2-A1 = 38

If you want to include both the starting and ending dates, then add 1

=A2-A1 + 1


--ron
 
Back
Top