| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Counting days between 2 dates
Is there a formula for calculating the number of days between two dates e.g.
1/1/09 and 1/31/09 = 31 days |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between 2 dates
A1 B1 C1
1/1/09 1/31/09 =B1-A1+1 "cockatoo" wrote: Is there a formula for calculating the number of days between two dates e.g. 1/1/09 and 1/31/09 = 31 days |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Counting days between 2 dates
Just subtract
=later-earlier of course you need to add 1 to that formula to get 31 -- Regards, Peo Sjoblom "cockatoo" wrote in message ... Is there a formula for calculating the number of days between two dates e.g. 1/1/09 and 1/31/09 = 31 days |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting days comparing 2 dates excluding empty cells | Excel Worksheet Functions | |||
| Counting Days Between Dates | Excel Worksheet Functions | |||
| Counting no of days from a list of running dates for a 12 month pe | Excel Discussion (Misc queries) | |||
| challenging formula(for me), counting days between dates for multipleyears | Excel Worksheet Functions | |||
| Counting days between dates | Excel Discussion (Misc queries) | |||
Linear Mode
