Wednesday, 13 March 2013

How to Find Count of Sundays Between Two Dates

How to Find Count of  Weekdays Between Two Dates
Suppose if you want find the count of no.of Sundays between two dates like March1,2013  and Macrch 31,2013 , you can find using a combi function[a function constructed with combination of multiple functions) as follows...

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


Example:

Suppose cell A2 has a date value March 1,2015  and cell B2  has a date value March 31,2015.. then If you want to find the no.of Fridays between these two date ranges you can find by using the following formula as shown below.

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





Hi My Dear Users....There are so many technologies and analytical reporting tools are available in the market...But Excel has it's own Significance in the Market...It is Basic and Base Reporting Tool....that's why I love Excel...Be and Excel in Excel...Follow my Kingdom...

I may not an Expert in Excel but Good @ Excel...Reporting.......
My Dream is to make my followers Excel in EXCEL...

Regards.,
Tamatam

No comments:

Post a Comment

Follow Me by Email

ExcelKingdom-Popular Posts

ExcelKingdom-Random Posts