Alwin
Alwin

Reputation: 117

Function within function to compare with current date (Excel)

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

Answers (1)

Scott Craner
Scott Craner

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

Related Questions