ExcelBanter - Counting Days Between Dates

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

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

- - Counting Days Between Dates (https://www.excelbanter.com/excel-worksheet-functions/176614-counting-days-between-dates.html)

JerryS

Counting Days Between Dates

What is an easy way to count the number of days between two dates? Thanks
--
JerryS

Niek Otten

Counting Days Between Dates

Hi Jerry,

YES!

=A1-B1

You see, a date in Excel is a number, representing the number of days since 1-1-1900.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"JerryS" wrote in message ...
| What is an easy way to count the number of days between two dates? Thanks
| --
| JerryS

All times are GMT +1. The time now is 02:11 AM.