| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting Days Between Dates
What is an easy way to count the number of days between two dates? Thanks
-- JerryS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Counting Days Between Dates
Hi Jerry,
YES! =A1-B1 You see, a date in Excel is a number, representing the number of days since 1-1-1900. -- Kind regards, Niek Otten Microsoft MVP - Excel "JerryS" wrote in message ... | What is an easy way to count the number of days between two dates? Thanks | -- | JerryS |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
| Conditional Formatting Dates calculating 10 days and 30 days from a certain date | 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
