Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating with dates
I have a question regarding days and substracting days as a date.
This is my excel sheet personal Day Day Day Remaining days Taken Taken Taken Days 3 05/07/07 06/05/07 1 Is there a way with a formula to calculate the remaining days without entering another column with a number ? I hope this is understandable. Thanks Henk |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating with dates
try:
=a2-counta(b2:d2:) so, days less the count of days taken (I'm assuming this is what you meant to do?) "Henk" wrote: I have a question regarding days and substracting days as a date. This is my excel sheet personal Day Day Day Remaining days Taken Taken Taken Days 3 05/07/07 06/05/07 1 Is there a way with a formula to calculate the remaining days without entering another column with a number ? I hope this is understandable. Thanks Henk |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating with dates
Yes it worked
Thanks for your help Henk "Lisa" wrote: try: =a2-counta(b2:d2:) so, days less the count of days taken (I'm assuming this is what you meant to do?) "Henk" wrote: I have a question regarding days and substracting days as a date. This is my excel sheet personal Day Day Day Remaining days Taken Taken Taken Days 3 05/07/07 06/05/07 1 Is there a way with a formula to calculate the remaining days without entering another column with a number ? I hope this is understandable. Thanks Henk |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating with dates
=A2-(C2-B2+1)
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Henk" wrote in message ... I have a question regarding days and substracting days as a date. This is my excel sheet personal Day Day Day Remaining days Taken Taken Taken Days 3 05/07/07 06/05/07 1 Is there a way with a formula to calculate the remaining days without entering another column with a number ? I hope this is understandable. Thanks Henk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating dates | Excel Worksheet Functions | |||
Calculating dates | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
I need help calculating dates? | Excel Worksheet Functions | |||
calculating dates | Excel Worksheet Functions |