Thread: calculating number of days between first day to last day, inclusiv
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
  
Posts: 4,624
Default 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.
Reply With QuoteReply With Quote