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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating inclusive dates
So just add 1 to make it inclusive.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "spike" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating inclusive dates
=cellref-cellref +1 if you want to include the day of receipt.
Gord Dibben MS Excel MVP On Sun, 2 Mar 2008 13:51:01 -0800, spike wrote: 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 |
Reply |
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) |