ExcelBanter - calculating number of days between first day to last day, inclusiv

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

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

- - calculating number of days between first day to last day, inclusiv (https://www.excelbanter.com/excel-worksheet-functions/167173-calculating-number-days-between-first-day-last-day-inclusiv.html)

Damian

calculating number of days between first day to last day, inclusiv

I was wandering what function or formula to us to calculate between and
including two dates. For example March 23 to March 23 would be one day.

JE McGimpsey

calculating number of days between first day to last day, inclusiv

One way:

A1: <date1
A2: <date2

A3: =A2 - A1 + 1

Format A3 as General or another Number format

In article ,
Damian wrote:

I was wandering what function or formula to us to calculate between and
including two dates. For example March 23 to March 23 would be one day.

All times are GMT +1. The time now is 01:56 PM.