how to count days excluding only sundays in a calender period.
"weekdays" excludes both saturdays and sundays.
thnks in advance
how to count days excluding only sundays in a calender period.
"weekdays" excludes both saturdays and sundays.
thnks in advance
Sinc you have Excel 2010
With
A1: start date.....01-Dec-2012
A2: end date.......31-Dec-2012
This regular formula returns the count of non-Sunday days in that date range:
Note: the "1000000" code flags 0's for workdays and 1's for non-workdays.![]()
Please Login or Register to view this content.
EDITED TO INCLUDE THIS Pre-XL2010 ALTERNATIVE:
Regular formula:
A4: =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&A2)))<>1))
For days to skip: 1=Sun, 2=Mon, 3=Tue, 4=Wed, 5=Thu, 6=Fri, 7=Sat
Is that something you can work with?
Last edited by Ron Coderre; 06-05-2014 at 01:42 PM.
Another way....
Try this Array Formula which requires confirmation with Ctrl+Shift+Enter instead of just Enter.
Assuming A1= Start Date and A2=End Date, then
![]()
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Or this Regular Formula.......
![]()
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks