Date comparison

[LindseyLofgren]

Hello all,

I have many entries on an excel sheet (each entry going horizontally A-H) and I would like excel to check if the current date is later than the goal date (column E), so to check if it is overdue. For overdue events, I then want that entire entry to be placed in another sheet in the workbook. Any suggestions? I'm a bit confused.

Thank you,
Lindsey

 

[Andrew Poulsom]

Welcome to the Board.

Enter a heading in I1, eg Overdue. In I2 enter:

=TODAY()>E2

and fill down. AutoFilter your data for column I equals True, select the visible cells the copy and paste them to the other sheet.