Excel fill cell with "YES" if the date is after today (Windows 10, Excel 2010)

Question

I want to use an IF function, to do something like:

"if date is after today, cell = YES, otherwise cell = blank"

I can't quite get my head around the double formula of pulling today's date within the IF function!

Could anyone help?

Thanks!

Answer 1

Try this formula:

=IF(A1>TODAY(),"YES","")