If function with dates

Hi Lennon

Before working with your live data make a backup so you can revert to your information in the event of encountering any problems.

It sounds like one of the items in your list is a date.
You'd like to add a cell for each item on your list to show 1 or 0 depending on whether this date is earlier or later than the date in D5

To do this put your date in the D5 cell
then for each record try the following formula:

=IF(B1>D$1,1,0)

where B1 in the formula above is the cell in your item that contains the date to be compared.

I hope this helps - let me know if you have any further questions.

Kind regards,
Andrew