Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating # of days
i have a spreadsheet that has a starting date, completion date, and the 3rd
column is elapsed # of days using formula =NETWORKDAYS(A2,B2) in column 3. Problem is if I don't have any date entered in completion date yet i get a negative # in column 3 example -28491 or -28473 where this should be zero until i enter the completion date. thx 2 all char |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculating # of days
"Charlene Lee" wrote in message
... i have a spreadsheet that has a starting date, completion date, and the 3rd column is elapsed # of days using formula =NETWORKDAYS(A2,B2) in column 3. Problem is if I don't have any date entered in completion date yet i get a negative # in column 3 example -28491 or -28473 where this should be zero until i enter the completion date. thx 2 all char Changing the formula to =IF(ISBLANK(B2),0,NETWORKDAYS(A2,B2)) should sort it. You could also swap the 0 for "" if you want C2 to be blank? V |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Days per month for calculating storage days | Excel Worksheet Functions | |||
calculating days | Excel Discussion (Misc queries) | |||
Calculating recurring date in following month, calculating # days in that period | Excel Worksheet Functions | |||
Calculating days | Excel Worksheet Functions |