Show first monday in next month and remind me when that day come

[hrzagi]

Hi. Can anyone help me with this. Every month on first monday or friday etc I have to do some tasks. Because there are many different days and tasks Im trying to make excell table with reminder. In cell A1 I have day in week when i need to do task, for example Monday. Now I would like to show in cell B1 the date of first Monday in next month. And when that day come I would like that cell become red and bold (for reminder). After I finish task I would press button and the cell B1 would show first Monday in next month. Hope so that you understand. I know that doesnt seems complicated and someone could say just write the date without code but I have many different conditions for differnet tasks and this is only one of them that i couldnt solve.

 

[Dave Patton]

The lower example will always show the next months specified date.
To make it static, instead of using Today() use the actual date.

Date and Time 2021.xlsm
	A	B	C	D
7			Instance
8	Monday	21-Jan-21	1	Mon 01-Feb-21
9
2b

Cell Formulas
Range	Formula
D8	D8	=WORKDAY.INTL(EOMONTH(B8,0),C8,REPLACE("1111111",MATCH(LEFT(A8,3),DOWS,0),1,0))

Date and Time 2021.xlsm
	A	B	C
1
2	Monday	Mon 01-Feb-21
3	Mon	Mon 01-Feb-21
4	Fri	Fri 05-Feb-21
5	Saturday	Sat 06-Feb-21
6
7		Instance
8	Wednesday	3	Wed 17-Feb-21
9
2b

Cell Formulas
Range	Formula
B2	B2	=WORKDAY.INTL(EOMONTH(TODAY(),0),1,"0111111")
B3:B5	B3	=WORKDAY.INTL(EOMONTH(TODAY(),0),1,REPLACE("1111111",MATCH(LEFT(A3,3),DOWS,0),1,0))
C8	C8	=WORKDAY.INTL(EOMONTH(TODAY(),0),B8,REPLACE("1111111",MATCH(LEFT(A8,3),DOWS,0),1,0))

To color the cell, try conditional formatting.