How do I find difference between two date entries in excel?
N Nick Hodge Oct 17, 2006 #3 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 [email protected] www.nickhodge.co.uk
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 [email protected] www.nickhodge.co.uk
