Greater than a "Date" argument

yashin11

Hi,

Does anyone know how to define a Greater than a "Date" argument in an IF statement?

For Example: = COUNTIFS( Sales:Sales, [Sold Date]:[Sold Date], 12/20/23)

Kelly Moore

Hey @yashin11

Try this

= COUNTIFS( Sales:Sales, [Sold Date]:[Sold Date], @cell>12/20/23)

Will that work for you?

Kelly