Hello,
I want to know how many Wednesdays, Saturdays and Sundays are between 2 days.
Can anyone help me with this?
Thanks
Hello,
I want to know how many Wednesdays, Saturdays and Sundays are between 2 days.
Can anyone help me with this?
Thanks
Hi
Just providing you a fancy solution...
There may be much better solution but check if it helps!!
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
Okay try this.. ( untested Though )
Start Date = A1
End Date = A2
B1 = (A2-A1) - Sum(Networkdays.Intl(A1, A2, {1,14}))
OR
B1 = (A2-A1) - (Networkdays.Intl(A1, A2, 14) + Networkdays.Intl(A1, A2, 1))
Regards,
Vikas Gautam
Excel-buzz.blogspot.com
Excel is not a matter of Experience, its a matter of Application.
Say Thanks, Click * Add Reputation
Hi
I found this online...
Where start date = A1 and end date = A2
=INT((WEEKDAY($A$1-2)-$A$1+$A2)/7)
1...Sunday
2...Monday
3...Tuesday
4...Wednesday
5...Thursday
6...Friday
7...Saturday
for adding Wed,Sat & Sun
=SUMPRODUCT(--(WEEKDAY(A1+ROW(INDIRECT("1:"&A2-A1)))={1,7,4}))
where a1 is start date & a2 end date
I'm not sure if you mean separately or a total of all 3 - NETWORKDAYS.INTL can actually be customised to count any combination of days, e.g. for the total Wednesdays, Saturdays and Sundays
=NETWORKDAYS.INTL(A2,B2,"1101100")
The zeroes in "1101100" indicate days to be counted, 1s are days to be excluded - the string starts with Monday, so to count Wednesdays alone
=NETWORKDAYS.INTL(A2,B2,"1101111")
Audere est facere
Nice.. Sir Long..
learnt a new thing today.
You are brilliant.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks