Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
Perhaps using Data Validation to only allow legitimate dates to be entered at
all. Then set your formula to stay blank until both cells have values. The one Mike suggested would be perfect. -- "Actually, I *am* a rocket scientist." -- JB Your feedback is appreciated, click YES if this post helped you. "Mike H" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
=IF(C6="","",C6-C5)
-- David Biddulph 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
that was the question. Is the answer before me? How do I set the forula cell
od D7 to stay blank until an actual date is in D6 D7 =d6-d5 d5 is empty most of the time. I would like D& to stay emty also, but hold the formula. Is it there? Did I miss it? Thanks "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
In D7?
"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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
Fanatastic! However, when I removed C6 It turned C7 Red!
My conditional formats in C7 are 1. if less than zero white 2. if greater than or equal to 1 red Can we keep D7 white until C6 is entered? You guys are so appreciated! "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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
David, that worked fine also, except it turned the cell C7 when I emptied C6.
Is there a way to keep it white. I have two conditionals for C7 1. if less than 1 pattern white 2. If greater than or equal to pattern red I want it white until Condition 2 with your formula Thanks. Mark "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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
subtracting dates leaves date/number or date
If you are trying to reply to someone's answer to your question, you need to
reply to that message, not to your original question, and you need to ensure that the relevant part of the reply is quoted, so that we can see what it is to which you think you are replying. As it is, we haven't a clue what you're talking about. -- David Biddulph Mark wrote: David, that worked fine also, except it turned the cell C7 when I emptied C6. Is there a way to keep it white. I have two conditionals for C7 1. if less than 1 pattern white 2. If greater than or equal to pattern red I want it white until Condition 2 with your formula Thanks. Mark "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 | |||
subtracting dates leaves date/number or date | Excel Worksheet Functions | |||
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) | |||
Count number of days between dates BUT IF null to current date | Excel Worksheet Functions |