count monday tuesday between two date
 

i want to count how many manday, wednesday and friday in between two
different date in excel

count monday tuesday between two date
 

Assuming that A2 contains the start date, and B2 contains the end date,
try the following...

To count the number of Mondays...

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2)=1))

To count the number of Mondays, Wednesdays, and Fridays...

=SUMPRODUCT(--ISNUMBER(MATCH(WEEKDAY(ROW(INDIRECT(A2&":"&B2)),2) ,{1,3,5},
0)))

Change the return type for the WEEDAY functions accordingly...

Monday = 1
Tuesday = 2
Wednesday = 3
Thursday = 4
Friday = 5
Saturday = 6
Sunday = 7

Hope this helps!

http://www.xl-central.com

In article ,
Amit Kumar Singh <Amit Kumar wrote:

i want to count how many manday, wednesday and friday in between two
different date in excel