| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
HOW TO CALCULATE THE DAYS?
i tried to write the formula to calculate the days.
A14(starting) B14 (ending) days including starting & ending 1/30/2005 02/01/2005 =DAYS360(A14,B14)+1 but I just can get 2 days. In fact it should be 3 days. I found that if there is 31 days in the month, the case will be like this. I tried to change the days360 to days363 in formula. But I am not allowed. tks in advance Sue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want the PMT function to calculate using 360 days not 365 | Excel Worksheet Functions | |||
| How do I calculate EDATE using days not months? | Excel Discussion (Misc queries) | |||
| How do I calculate difference in days & hours between two dates e. | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
| Calculate # of Days from one date to another | Excel Worksheet Functions | |||
Threaded Mode
