ExcelBanter - count days from a one date to another date

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - count days from a one date to another date (https://www.excelbanter.com/excel-worksheet-functions/219247-re-count-days-one-date-another-date.html)

Mike H

count days from a one date to another date

"confused!!",

There's no need to be

=A1-B1

and format as General

Mike

"confused!!" wrote:

If in cell A1 i have a date 09/17/09 and date 10/30/08 in B1 i need to count
the number of days from A1 to B1

Please provide formula for doing so.

All times are GMT +1. The time now is 11:12 PM.