Alert - First Monday of the Month
Results 1 to 6 of 6

Thread: Alert - First Monday of the Month
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2010
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Alert - First Monday of the Month

    I'd like to have the word Project appear in cell E2 on the first Monday of each month. Any ideas on how to do that?

  2. #2
    Board Regular Scott T's Avatar
    Join Date
    Dec 2016
    Posts
    2,510
    Post Thanks / Like
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Alert - First Monday of the Month

    Try
    I assume you want E2 blank if it is not the first Monday
    Code:
    =IF(TODAY()=EOMONTH(TODAY(),-1)+1+CHOOSE(WEEKDAY(EOMONTH(TODAY(),-1)+1,2),0,6,5,4,3,2,1),"project","")
    Colonel Sandurz: Prepare ship for light speed.
    Dark Helmet: No, no, no, light speed is too slow.
    Colonel Sandurz: Light speed, too slow?
    Dark Helmet: Yes, we're gonna have to go right to ludicrous speed.

  3. #3
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,593
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Alert - First Monday of the Month

    try this formula in E2

    =IF(TODAY()=EOMONTH(TODAY(),-1)+(7-WEEKDAY(EOMONTH(TODAY(),-1),2)+1),"Project","")

  4. #4
    Board Regular
    Join Date
    Mar 2010
    Posts
    101
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Alert - First Monday of the Month

    Thanks to you both...will wait and see if it works!

  5. #5
    Board Regular sykes's Avatar
    Join Date
    May 2002
    Location
    Cornwall,England
    Posts
    1,560
    Post Thanks / Like
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Alert - First Monday of the Month

    I went for this...
    =IF(AND(DAY(TODAY())<8,TEXT(TODAY(),"DDD")="Mon"),"Project","Not frst Mon")
    Sykes
    Windows 10 / XL 2016
    Members don't have crystal balls, so PLEASE describe your situation, code,
    and requirements ACCURATELY in your first post. It saves hair!
    Better still - upload your spreadsheet (and formulae!) with this great bit of kit.


    - forum use guidelines, forum rules and terms of use
    - Try searching for your answer first, see how
    - Read the FAQs
    - List of BB codes

  6. #6
    Board Regular
    Join Date
    Mar 2015
    Posts
    3,593
    Post Thanks / Like
    Mentioned
    62 Post(s)
    Tagged
    7 Thread(s)

    Default Re: Alert - First Monday of the Month

    another one using @sykes method

    =IF(AND(DAY(TODAY())<8,WEEKDAY(TODAY())=2),"Project","")

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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