IF(ISBLANK Returns #VALUE!

[MrDB4Excel]

In this workbook, I have tried in vain to get cells to show nothing when there is no value in specific cells.
Cells A2 to A8 show a date while cells A9 to A11 are blank.
Cells C2 to C11 has the formula =IF(ISBLANK(A2),"",A2); obviously each successive row the row number changes, for example:
In cell C2 is =IF(ISBLANK(A2),"",A2) then in cell C3 is =IF(ISBLANK(A3),"",A3)…
Why then do cells B9 to B11 show #VALUE!

Conversations with RobJessee-RJ.xlsx
	A	B	C
1	Date	Year
2	02/05/2022 15:20:17	2022	02/05/2022 15:20:17
3	02/08/2022 18:52:29	2022	02/08/2022 18:52:29
4	02/08/2022 19:45:46	2022	02/08/2022 19:45:46
5	02/08/2022 19:31:58	2022	02/08/2022 19:31:58
6	02/08/2022 19:48:35	2022	02/08/2022 19:48:35
7	02/08/2022 19:52:11	2022	02/08/2022 19:52:11
8	02/08/2022 19:53:18	2022	02/08/2022 19:53:18
9		#VALUE!
10		#VALUE!
11		#VALUE!
BogusData

Cell Formulas
Range	Formula
B2:B11	B2	=YEAR(C2)
C2:C11	C2	=IF(ISBLANK(A2),"",A2)

 

[earthworm]

Try below

Book1
	A	B	C
1	Date	Year
2	02-05-22 15:20	2022	44683.6391
3	02-08-22 18:52	2022	44775.7864
4	02-08-22 19:45	2022	44775.8234
5	02-08-22 19:31	2022	44775.8139
6	02-08-22 19:48	2022	44775.8254
7	02-08-22 19:52	2022	44775.8279
8	02-08-22 19:53	2022	44775.8287
Sheet1

Cell Formulas
Range	Formula
B2:B8	B2	=IFERROR(YEAR(C2),"")
C2:C8	C2	=IF(ISBLANK(A2),"",A2)

Error was appearing because there was no value in column C9 onwards which was expected by year formula

 

[MrDB4Excel]

Perfect, thank you so much earthworm.