| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Formula to calculate number of days between Dates
Afternoon. I have 2 lists of dates... one is for an estimated delivery date and the second is the actual date. If the date's do not match ( the delivery is late) then i need it to calculate the number of days that its late. How can i do this calculation for a date format? Thanks James -- themax16 ------------------------------------------------------------------------ themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622 View this thread: http://www.excelforum.com/showthread...hreadid=478181 |
|
#2
|
|||
|
|||
|
Formula to calculate number of days between Dates
Just subtract one from the other, and format as General.
-- HTH RP (remove nothere from the email address if mailing direct) "themax16" wrote in message ... Afternoon. I have 2 lists of dates... one is for an estimated delivery date and the second is the actual date. If the date's do not match ( the delivery is late) then i need it to calculate the number of days that its late. How can i do this calculation for a date format? Thanks James -- themax16 ------------------------------------------------------------------------ themax16's Profile: http://www.excelforum.com/member.php...o&userid=23622 View this thread: http://www.excelforum.com/showthread...hreadid=478181 |
|
#3
|
|||
|
|||
|
Formula to calculate number of days between Dates
On Fri, 21 Oct 2005 05:31:37 -0500, themax16
wrote: Afternoon. I have 2 lists of dates... one is for an estimated delivery date and the second is the actual date. If the date's do not match ( the delivery is late) then i need it to calculate the number of days that its late. How can i do this calculation for a date format? Thanks James In Excel, dates are stored as serial numbers. So if your Estimated Date is in A1, and the Actual date in B1, the difference would be given by: =B1-A1 You must format the result as General or Number. Otherwise Excel will display some date in the 1900's --ron |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Number of years, months, days between two dates. | Excel Worksheet Functions | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
| Calculate number of days in a column of dates | Excel Discussion (Misc queries) | |||
| how do I calculate the days between dates? | Excel Discussion (Misc queries) | |||
| Looking for function or formula to calculate number that is revers | Excel Worksheet Functions | |||
Hybrid Mode
