Date comparison

LindseyLofgren

New Member
Joined
Sep 22, 2008
Messages
8
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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.
 

Forum statistics

Threads
1,082,438
Messages
5,365,531
Members
400,837
Latest member
ELMST616

Some videos you may like

This Week's Hot Topics

Top