| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating number of days between first day to last day, inclusiv
I was wandering what function or formula to us to calculate between and
including two dates. For example March 23 to March 23 would be one day. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating number of days between first day to last day, inclusiv
One way:
A1: <date1 A2: <date2 A3: =A2 - A1 + 1 Format A3 as General or another Number format In article , Damian wrote: I was wandering what function or formula to us to calculate between and including two dates. For example March 23 to March 23 would be one day. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating Number of days from one date to another | Excel Discussion (Misc queries) | |||
| Calculating number of hours between two days | Excel Worksheet Functions | |||
| Calculating the number of days worked | Excel Worksheet Functions | |||
| calculating number of days (e.g., Mondays) between two dates | Excel Worksheet Functions | |||
| Calculating number of days | Excel Worksheet Functions | |||
Linear Mode
