Blank a dated cell

[AlanStrobel]

Trying to get the highlighted cells with Friday date to be be blank if it should and filled in if there is a 5th Friday.

 

[etaf]

why is the 2nd feb not highlighted

you could use conditional formatting and change font

using something like
=WEEKDAY(A1,1)=6
where a1 is a date

how do you know the year

what version of excel

Book3
	A	B
14	Monday	FALSE
15	Tuesday	FALSE
16	Wednesday	FALSE
17	Thursday	FALSE
18	Friday	TRUE
19	Saturday	FALSE
20	Sunday	FALSE
21	Monday	FALSE
22	Tuesday	FALSE
23	Wednesday	FALSE
24	Thursday	FALSE
25	Friday	TRUE
26	Saturday	FALSE
27	Sunday	FALSE
28	Monday	FALSE
29	Tuesday	FALSE
30	Wednesday	FALSE
31	Thursday	FALSE
32	Friday	TRUE
33	Saturday	FALSE
34	Sunday	FALSE
35	Monday	FALSE
36	Tuesday	FALSE
37	Wednesday	FALSE
Sheet2

Cell Formulas
Range	Formula
B14:B37	B14	=WEEKDAY(A14,1)=6

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A14:B37	Expression	=WEEKDAY(A14,1)=6	text	NO

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also, can you give us some sample data with XL2BB that includes some months that do have 5 Fridays as well as some months that do not have 5 Fridays?
(If you have trouble with XL2BB, review the "XL2BB Icons greyed out" link in the 'Known XL2BB issues' section near the top of the XL2BB Instructions page linked above.)

 

[kvsrinivasamurthy]

The 5th Friday Shown in Fig belongs to next Minth. What is actually required is not clear. Pl Show what is the expected result.

 

[kvsrinivasamurthy]

On guess. Try.
In T3 copied down.

=IF(ROWS($T$3:$T3)=1,DATE(2024,1,1)+6-WEEKDAY(DATE(2024,1,1),1),IF(MOD(ROWS($T$3:$T3),5)=0,IF(MONTH($T2+7)=MONTH($T2),$T2+7,""),MAX($T$2:$T2)+7))

Format Cells as
Custom --> d mmm