Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date Count
Please help, I know this is probably a really quite simple function but i have been puzzling over this for couple of hours now.
I am trying to work out the formula that will provide the number of days between two different dates for example 10/01/2005 - 10/13/2005 = ## days (american date format). If anyone could provide assistance that would be great and save me a lot of hassle. Thanks Shoulders |
#2
|
|||
|
|||
Assuming date1 in cell A1 < date2 in cell A2
the difference in A3: =A2-A1 then format A3 as General Stefi "shoulders" wrote: Please help, I know this is probably a really quite simple function but i have been puzzling over this for couple of hours now. I am trying to work out the formula that will provide the number of days between two different dates for example 10/01/2005 - 10/13/2005 = ## days (american date format). If anyone could provide assistance that would be great and save me a lot of hassle. Thanks Shoulders -- shoulders |
#3
|
|||
|
|||
On Thu, 13 Oct 2005 10:12:25 +0100, shoulders
wrote: Please help, I know this is probably a really quite simple function but i have been puzzling over this for couple of hours now. I am trying to work out the formula that will provide the number of days between two different dates for example 10/01/2005 - 10/13/2005 = ## days (american date format). If anyone could provide assistance that would be great and save me a lot of hassle. Thanks Shoulders If your first date is in A1; and your later date is in A2, then the formula is: =A2-A1 (format as General or Number) Excel stores dates as serial numbers starting with 1/1/1900. So to get the number of days between dates, you merely need to subtract one from the other. --ron |
#4
|
|||
|
|||
DATEDIF (StartDate,EndDate,"D"). The third argument of the function "D"
returns the number of Days between StartDate and EndDate. =DATEDIF(A2,A3,"D") other options "y" Year, "m" Month Lenny |
#5
|
|||
|
|||
Shoulders, Set a formula to subtract the dates as if they were numbers =A2-A1 for instance. The Date Time setup in your control panel will have to be set to the US format so the computer understands that there are not 13 months in the year. Once you're done that the format of the cell that contains the answer will have to be formatted to number (not days else it won't count over 30 days) Regards -- Jon Quixley ------------------------------------------------------------------------ Jon Quixley's Profile: http://www.excelforum.com/member.php...o&userid=25803 View this thread: http://www.excelforum.com/showthread...hreadid=475809 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
count date ranges | Excel Worksheet Functions | |||
How do I count occurences in a date range? | Excel Worksheet Functions | |||
Imported Date & Time format with calcs. managed in excel from imrp | Excel Worksheet Functions | |||
Count the occurances of a month in a range of date fields | Excel Worksheet Functions |