Hi,
I had a formula that uses a start and end date and the excel value for Monday (2) to return the number of mondays there are between two dates.
For the life of me, I can't find it now - anyone have this?
Cheers
Phil
=SUMPRODUCT(--(WEEKDAY(StartDate-1+ROW(INDIRECT("1:"&(EndDate-StartDate+1))))=2))
red 2 can be changed to 1=sun .. 7 = sat
Regards
Darren
Update 12-Nov-2010 Still job hunting!
If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.
Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!
You dancing bear!
Thanks - works a treat.
Phil
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks