Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Here is my issue for dates in Excel (2003).
I have 3 columns with dates for which I want to calculate the number of days that have elapsed between the date sent and the date received. I am trying to calculate the the fastest receipt date for items sent. Col 1 has the date sent. Col 2 has the date for one method of receipt. Col 3 has the date for the other method of receipt. I want the next column to calculate the number of days between Col 1 and either col 2 or col 3, depending on whether there is a date in the column. Here is an example of the information. Column G would contain the formula for the number of days. D E F G 5 12/21/05 no data 12/28/05 # days 6 12/21/05 1/16/06 no data # days Thank you for your assistance. Tea |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I use the concatenate function to add a date into a sentenc | Excel Worksheet Functions | |||
workday date function | Excel Worksheet Functions | |||
specific date function | Excel Worksheet Functions | |||
Date Function | Excel Discussion (Misc queries) | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel |