+ Reply to Thread
Results 1 to 2 of 2

Formula for 1st week of month

  1. #1
    Forum Contributor
    Join Date
    08-17-2012
    Location
    Richmond, VA
    MS-Off Ver
    Excel 2007
    Posts
    158

    Formula for 1st week of month

    Hello,

    I need a formula that will only look at the first week of the month. If the date is not the first week, then return a blank.

    Let’s use 08/01/2013 for an example:

    For the week of 08/01/2013, Sunday is the beginning of the week which is 07/28/2013 and Saturday is the end of the week which is 08/03/2013. I need a formula that will tell me, where the first lies in the particular weekday. If the 1st of the month shows up on a Thursday or Friday, then I want the formula to return “Next Week”. If the 1st of the month falls on a Monday, Tuesday, or a Wednesday, then I want the formula to return “This Week”. Please let me know if you need any clarification.

    Thanks!

  2. #2
    Valued Forum Contributor Melvinrobb's Avatar
    Join Date
    06-19-2012
    Location
    Manitoba, Canada
    MS-Off Ver
    Excel 2013
    Posts
    1,128

    Re: Formula for 1st week of month

    What value would you enter into a cell?
    I believe you are saying that if August 17th were put in a cell, the formula would determine that August 1, 2013 is on a Thursday, and return "Next Week". Is that correct?
    Please click the * icon below if I have helped.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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