View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Calculating number of days including the start and end date

Hi,

If they are legal Excel dates then
=A1-B1+1

Where A1 is the End date and B1 is the start date. The format the cell to
Number.

If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"Terri" wrote:

I need to calculate the number of days between two dates including the start
date and end date. (i.e., Start Date: April 3, End Date: April 5 - Answer
would be 3, but I only get 2)

Any info would be appreciated.

Many thanks.