ExcelBanter - Days between two dates?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Days between two dates? (https://www.excelbanter.com/excel-discussion-misc-queries/445668-days-between-two-dates.html)

Terry Pinnell[_2_]

Days between two dates?

Given two dates, say in the (UK) format dd/mm/yyyy, could one of the
experts define an Excel formula that would return the number of days
between them please?

--
Terry, East Grinstead, UK

Ron Rosenfeld[_2_]

Days between two dates?

On Tue, 03 Apr 2012 22:38:44 +0100, Terry Pinnell wrote:

Given two dates, say in the (UK) format dd/mm/yyyy, could one of the
experts define an Excel formula that would return the number of days
between them please?

=date2 - date1
Format as General or as Number

All times are GMT +1. The time now is 03:42 PM.