Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating inclusive dates
How many days including 1/1/2008 through 1/31/2008.
If you use the between dates calc cell#-cell# you will get 30 when there are actually 31 days including the 1st day. The problem is when a payment is made for a period calculating the number of days, including the date of receipt. e.g 4/15/2007 thru 5/14/2007 or 2/1/2007 thru 3/15/2007 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Printing/# pages inclusive of tabs at bottom | Excel Worksheet Functions | |||
Custom filter will not return characters between 1-9 inclusive | Excel Discussion (Misc queries) | |||
how do I merge columns in excel inclusive of content | Excel Discussion (Misc queries) | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Inclusive/Exclusive List | Excel Discussion (Misc queries) |