Reputation: 117
I have a column with various dates and want to check if the date is equal or after the 1st January of the current year. I use the following code to get the 1st January of the current year.
="01.01."&YEAR(TODAY())
How would I insert this into a formula to check if the date in cell B3 is equal or after the given date? The following is not working
=IF(B3>=""01.01."&YEAR(TODAY())";True;False)
Upvotes: 0
Views: 51
Reputation: 152450
Try
=B3>=DATE(YEAR(TODAY());1;1)
This will return TRUE or FALSE. No need for the IF() statement if all you want is a TRUE/FALSE.
Upvotes: 1