# Alert - First Monday of the Month

#### Hydestone

##### Board Regular
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?

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### Scott T

##### Well-known Member
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","")``

#### Yongle

##### Well-known Member
try this formula in E2

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

#### Hydestone

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

#### sykes

##### Well-known Member
I went for this...
=IF(AND(DAY(TODAY())<8,TEXT(TODAY(),"DDD")="Mon"),"Project","Not frst Mon")

#### Yongle

##### Well-known Member
another one using @sykes method

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

1,101,911
Messages
5,483,679
Members
407,399
Latest member
Rakeforms

### This Week's Hot Topics

• Finding issue in If elseif else with For each Loop
Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
• MsgBox Error
Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
• CELL FORMAT - IF CONDITION
My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
• Show numbers nearly the same
Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...