If cell (formatted as long date) contains Friday

[LLPlates]

Good Morning,
Please could someone assist me with this, I have tried a lot of things and it may not be possible.
I have a column which is showing certain dates in the format e.g. Friday, 27 March 1998.
What I would like to do is split this information down further to search for different days but cannot
get IF to pick out the days in the cell. Is this possible?
Thank you for reading.
LL Plates

 

[AhoyNC]

Try the WEEKDAY function.

Book1
	A	B
1	3/24/1998
2	3/25/1998
3	3/26/1998
4	3/27/1998	Friday
5	3/28/1998
6	3/29/1998
7	3/30/1998
8	3/31/1998
9	4/1/1998
10	4/2/1998
11	4/3/1998	Friday
12	4/4/1998
13	4/5/1998
14	4/6/1998
15	4/7/1998
16	4/8/1998
17	4/9/1998
Sheet1

Cell Formulas
Range	Formula
B1:B17	B1	=IF(WEEKDAY(A1,1)=6,"Friday","")

 

[LLPlates]

Thank you so much
Will this work with Months and years also?

 

[AhoyNC]

You can use the MONTH and YEAR functions for that.

 

[LLPlates]

You can use the MONTH and YEAR functions for that.

A HUGE thank you. Enjoy your day ☺

 

[LLPlates]

Hi again,
Thanks to your help I have got my sheet further along. thank you.
I have encountered a challenge where if the cell is blank, I am getting #VALUE!
Have tried an IF AND (if the cell is greater than 0 and then your formula but am getting error, so either I have not written it properly or if and doesn't work for weekdays.
Any advice please?

 

[AhoyNC]

Can you post a small sample and the formula you are trying to use?
Should be able to use something like.
IF(A1="","",Then the formula here)

 

[LLPlates]

Can you post a small sample and the formula you are trying to use?
Should be able to use something like.
IF(A1="","",Then the formula here)

Hi, Thank you for your reply.
I have tried that but no luck.
As long as column K is populated this works fine with all the days but I get the #VALUE! when
it is not.

 

[AhoyNC]

My guess is the cell is not really blank. Try using the ISBLANK function like in the example below to see if the cell is blank.
Try the formula in cell L10 to see if that works for you.

IFERROR(IF(WEEKDAY(K10,1)=6,"Friday",""),"")

Book1
	K	L	M
1	Thursday, March 26, 1998
2	Friday, March 27, 1998	Friday
3			TRUE
4	Sunday, March 29, 1998
5	Monday, March 30, 1998
6		#VALUE!	FALSE
7	Wednesday, April 8, 1998
8	Thursday, April 9, 1998
9	Friday, April 10, 1998	Friday
10			FALSE
Sheet1

Cell Formulas
Range	Formula
M3,M10,M6	M3	=ISBLANK(K3)
L1:L5,L7:L9	L1	=IF(WEEKDAY(K1,1)=6,"Friday","")
L6	L6	=TRIM(IF(WEEKDAY(K6,1)=6,"Friday",""))
L10	L10	=IFERROR(IF(WEEKDAY(K10,1)=6,"Friday",""),"")

 

[LLPlates]

Thank you very much for your patience and continued help.
This works and the formulas are so handy.
Enjoy your day!