I am trying to make a formula that tells me how many Mondays, Tuesday, etc... are left in the current month. I have =today() in cell E2 and I want to lookup against the day name, (Monday, Tuesday, Wednesday, etc...), that are in row 7 from B:H starting with Sunday in B7. The lookup against the day name isn't important if anyone can think of an easier way without it.
Last edited by JuJuBe; 09-20-2010 at 06:52 PM.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
Try this formula in B8 copied across to H8
=INT((WEEKDAY($E2-COLUMNS($B7:B7))+EOMONTH($E2,0)-$E2)/7)
Audere est facere
Thanks daddy long legs, that works perfecto!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks