Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
Hi,
Several ways and here's one =IF(COUNT(C6,C5)=2,C6-C5,"") Mike "Mark" wrote: Across the columns there are projected dates in row C5 C6 is empty, but "will" contain Actual dates C7 is =C6-C5 formatted to number My problem or question is without and "Actual" date in C6 I get a "numerical date" in C7 , because it is calculating C6 against C5. thus rendering C7 with a numerical value of C5. Is it possible to have C7 (with the formula)stay blank or white until and actual date is placed in C6? Thank you once, again, and for the numerous helps today. Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Number of dates falling in a date range | Excel Worksheet Functions | |||
counting the number of dates in a date range | Excel Worksheet Functions | |||
Deleting time part of a Date, subtracting dates | Excel Discussion (Misc queries) | |||
Number of days between 2 dates, if end date is blank assume todays | New Users to Excel | |||
Count number of days between dates BUT IF null to current date | Excel Worksheet Functions |