To calculate number of days including start date

**gautham_p** · 03-28-2012, 05:20 AM

Hi,

I want to calculate number of days between two dates, including start date also.
For Example
A B C (No.of days)
23/03/2012 30/03/2012 8
28/03/2012 28/03/2012 1

I dont want to use networkdays function, since it excludes weekends. (I want to include saturdays & sundays also)
right now I am using =(B2-A2)+1

Is it any other formula available.

**Russell Dawson** · 03-28-2012, 05:42 AM

Why would you need another formula? This performs exactly as you want it. You could put it another way: =B2-A2+1

**gautham_p** · 03-28-2012, 06:07 AM

Yeah it gives me the required result, but I just want to know whether any other function available in excel to calculate the same.

**daddylonglegs** · 03-30-2012, 08:19 AM

I'd stay with your current formula but DATEDIF would also give you the same result and might have some advantages (if you start and end dates contain times, for instance)

=DATEDIF(A2,B2,"d")+1

**gautham_p** · 04-09-2012, 06:56 AM

Hi Thanks a lot. It was very useful. Because I have faced same issue. My date had time in that and manually i have changed the decimal values to zero to get the whole number.

**cloucl** · 05-11-2016, 04:55 AM

Hi, what if I want to count the number of saturdays between 2 dates and include the saturday if it's either the start date or end date or both.

**FDibbins** · 05-11-2016, 10:47 AM

cloudcl, welcome to the forum

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.