When "A1" is 1st working day of the month, fill "B1" with "50" else "0"

[bobtimmer]

The goal is when "A1" is 1st working day of the month, fill "C1" with "50" else "0"

I have a date in A1. EXAMPLE: 12/1/2023
I have the formula to the right in B1. =A1=WORKDAY(DATE(YEAR(A1),MONTH(A1),0),1)
I have the formula to the right in C1. =IF(DAY(B1) = 1,50,0)

How can I join the formulas in B1 and C1 into a single formula?

 

[etaf]

=WORKDAY(EOMONTH(A1,-1), 1)
A1=WORKDAY(EOMONTH(A1,-1), 1)
then an IF
=IF(A1=WORKDAY(EOMONTH(A1,-1), 1),50,0)

Book1
	A	B
1	12/1/23	50
2	12/2/23	0
3	11/3/23	0
Sheet1

Cell Formulas
Range	Formula
B1:B3	B1	=IF(A1=WORKDAY(EOMONTH(A1,-1), 1),50,0)

 

[Scott Huish]

No IF necessary.
=(WORKDAY(EOMONTH(A1,-1),1)=A1)*50

 

[bobtimmer]

Both work but I could only check one. Thanks so much to both of you!!

 

[etaf]

you are welcome