Alert - First Monday of the Month

Hydestone

Board Regular
Joined
Mar 29, 2010
Messages
124
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?
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Scott T

Well-known Member
Joined
Dec 14, 2016
Messages
2,611
Office Version
365, 2016
Platform
Windows
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
Joined
Mar 11, 2015
Messages
6,007
Office Version
365
Platform
Windows
try this formula in E2

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

sykes

Well-known Member
Joined
May 1, 2002
Messages
1,649
Office Version
365
Platform
Windows
I went for this...
=IF(AND(DAY(TODAY())<8,TEXT(TODAY(),"DDD")="Mon"),"Project","Not frst Mon")
 

Yongle

Well-known Member
Joined
Mar 11, 2015
Messages
6,007
Office Version
365
Platform
Windows
another one using @sykes method

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

Watch MrExcel Video

Forum statistics

Threads
1,099,010
Messages
5,466,008
Members
406,460
Latest member
tryingtogoalone

This Week's Hot Topics

Top