Results 1 to 4 of 4

Number of Mondays left in current month

Threaded View

JuJuBe Number of Mondays left in... 09-20-2010, 05:39 PM
Palmetto Re: Number of Mondays left in... 09-20-2010, 06:05 PM
daddylonglegs Re: Number of Mondays left in... 09-20-2010, 06:42 PM
JuJuBe Re: Number of Mondays left in... 09-20-2010, 06:51 PM
  1. #1
    Registered User
    Join Date
    03-05-2010
    Location
    Oregon
    MS-Off Ver
    Excel 2007
    Posts
    75

    Number of Mondays left in current month

    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1