DATE Function?

[B. Baumgartner]

Hello, I have a formula where I am using an IF statement that needs to meet 3 criteria. The third criteria that needs to be met is that cell b30 should be less than today's date. I thought the function would look like this:

=IF((AND(C30<1,D30<=1,K30="Workday",B30<DATE)),"Please Select Reason","")

However, I get a ?Name error when I use that. What is the correct syntax.

thanks,

Boyd

[Alex Delamain]

The problem is that "date" is not a function. Change "Date" for today() and it will work

=IF((AND(C30<1,D30<=1,K30="Workday",B30<TODAY())),"Please Select Reason","")