Date is in current year?

[Cellpod]

Hi all... is there a formula that would return TRUE if the date in a cell is in Current year?

For example, in A1, i type in the date... I would like B1 to say "TRUE" or "Current Year"

Thanks in advance!

 

[DSCfromCFA]

In Cell B1
=IF(YEAR(TODAY())=YEAR(A1),"TRUE","False")

Replace True/False with any required wording

Cheers

shane

 

[Cellpod]

In Cell B1
=IF(YEAR(TODAY())=YEAR(A1),"TRUE","False")

Replace True/False with any required wording

Cheers

shane

Thank YOU so much Shane!

 

[DSCfromCFA]

You're welcome, and thanks for the feedback.

Cheers