Formula using a Data within it

[gheyman]

I want to use a date as a criteria in my formula. How I typically do this is =IF(B5>A1,...... Where B5 is a date and A1 is a date. Or If(B5<NOW()....

But what I am trying to do here is put an actual date in the formula. I want to see if B5 is > January 01,2019. Do I have to put 1/1/2019 in another cell and reference it in the formula or is there a way to actually put the January date in the formula?

Thanks

 

[Joe4]

Do I have to put 1/1/2019 in another cell and reference it in the formula or is there a way to actually put the January date in the formula?

That is one way.

Here are some others:
=IF(B5 > DATE(2019,1,1),...
=IF(B5 > DATEVALUE("January 1, 2019"),...

 

[AlanY]

your date can be represented as

=DATE(2019,1,1)

 

[gheyman]

Thank you both!

 

[AlanY]

you're welcome