| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates
How do i calculate the number of days between 3 dates, 09/01/2006 thru 01/23/06
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Dates
Just subtract:
A1 = 9/1/2006 A2 = 1/23/2006 =A1-A2 Format as GENERAL or NUMBER Result = 221 Biff "DHM" wrote in message ... How do i calculate the number of days between 3 dates, 09/01/2006 thru 01/23/06 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating number of three month periods between two dates... | Excel Discussion (Misc queries) | |||
| working out quarters (three-month periods) between two dates | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
| 2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
Linear Mode
