| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Difference between two date entries in excel?
How do I find difference between two date entries in excel?
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Difference between two date entries in excel?
Just subtract:
A1 = 9/1/2006 B1 = 10/17/2006 =B1-A1 Biff "Novell" wrote in message ... How do I find difference between two date entries in excel? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Difference between two date entries in excel?
Novell
Biff's solution will give you the difference between the dates in days (and hours if present). If you need another date interval, eg months, years, etc, you could use the un-documented (except in XL2000) DATEDIF function A documentation is here http://www.cpearson.com/excel/datedif.htm -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS www.nickhodge.co.uk "Novell" wrote in message ... How do I find difference between two date entries in excel? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel date format trouble | Excel Discussion (Misc queries) | |||
| Excel: I enter date and format for date, but shows as number | Excel Discussion (Misc queries) | |||
| excel array formula | Excel Worksheet Functions | |||
| Launch excel showing today's date | Excel Discussion (Misc queries) | |||
| Excel formula with date constraints | Excel Discussion (Misc queries) | |||
Linear Mode
