| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to subtract 2 dates to get number of days.....please
I've tried fornatting, to no avail.......I'm on Excel '97.
Cheers Nick |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to subtract 2 dates to get number of days.....please
Hi Nick,
Just subtract the oldest date from the newer one and format the result as General or Number, not Date. -- Kind regards, Niek Otten Microsoft MVP - Excel "Nick" wrote in message ... | I've tried fornatting, to no avail.......I'm on Excel '97. | | Cheers | | Nick | | |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to subtract 2 dates to get number of days.....please
Nick,
Simple subtraction will work. Excel stores dates internally as numbers. When one of the cells involved in an arithmetic operation has a certain format Excel often uses the same format for the output. You have two options: =B2-A2 and format the cell as general. Or, =VALUE(B2-A2) HTH Kostis Vezerides Nick wrote: I've tried fornatting, to no avail.......I'm on Excel '97. Cheers Nick |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How to subtract 2 dates to get number of days.....please
you could use
=datedif(Date1,Date2,"d") datedif() is a useful function in EXCEL, but you won't find it in help "Nick" wrote: I've tried fornatting, to no avail.......I'm on Excel '97. Cheers Nick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculate Number of Months Weeks and Days Between Two Dates | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
| Number of years, months, days between two dates. | Excel Worksheet Functions | |||
| Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Linear Mode
