Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calculate day for day
I need a formula to calculate day for day for a 365 year. The only function
I can find in excel is days360. For example: If I took a vacation from 1 mar 04 thru 10 mar 04 that would be 10 days. Which I can do with SUM +1 but if the cells are blank I need the amount of days to be zero (or blank) not 1. |
#2
|
|||
|
|||
Hi
Try something like this: =((C8-C7)+AND(C70,C80))*(AND(C70,C80)) -- Andy. "AG" wrote in message ... I need a formula to calculate day for day for a 365 year. The only function I can find in excel is days360. For example: If I took a vacation from 1 mar 04 thru 10 mar 04 that would be 10 days. Which I can do with SUM +1 but if the cells are blank I need the amount of days to be zero (or blank) not 1. |
#3
|
|||
|
|||
First of all, no need to use days360, it's an obscure function for accountants,
nor do you need sum, you can just subtract, i.e. A1 holds start date and B1 end date =IF(OR(A1="",B1=""),0,B1-A1+1) will take care of blank days as well format as general you might also want to look at the networkdays function, it is part of ATP and comes with excel/office, it will count workdays only Regards, Peo Sjoblom "AG" wrote: I need a formula to calculate day for day for a 365 year. The only function I can find in excel is days360. For example: If I took a vacation from 1 mar 04 thru 10 mar 04 that would be 10 days. Which I can do with SUM +1 but if the cells are blank I need the amount of days to be zero (or blank) not 1. |
#4
|
|||
|
|||
Thanks!
"Peo Sjoblom" wrote: First of all, no need to use days360, it's an obscure function for accountants, nor do you need sum, you can just subtract, i.e. A1 holds start date and B1 end date =IF(OR(A1="",B1=""),0,B1-A1+1) will take care of blank days as well format as general you might also want to look at the networkdays function, it is part of ATP and comes with excel/office, it will count workdays only Regards, Peo Sjoblom "AG" wrote: I need a formula to calculate day for day for a 365 year. The only function I can find in excel is days360. For example: If I took a vacation from 1 mar 04 thru 10 mar 04 that would be 10 days. Which I can do with SUM +1 but if the cells are blank I need the amount of days to be zero (or blank) not 1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate time | Excel Discussion (Misc queries) | |||
How can I calculate Vacation Time earned based on length of emplo. | Excel Discussion (Misc queries) | |||
formula to calculate # of days between dates, excluding holidays | Excel Discussion (Misc queries) | |||
Not able to calculate. | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |