EricM
05-24-2008, 05:40 PM
I am trying to search a colum for any date older then 1 day and to add it to a report to print out or email. I have tried numerous examples found here using datedif and dateserial and cannot seem to get them to work.My date format is mm/dd/yyyy. I cannot seem to get it to find anything.
Could someone please post or guide me in how to search Column "d2 - ?" (the first entry is in d2 but rows are added continuously) when a workbook opens.
I want to find every row the is 1 day old or more
attached is a example workbook.
Excel 2003
Could someone please post or guide me in how to search Column "d2 - ?" (the first entry is in d2 but rows are added continuously) when a workbook opens.
I want to find every row the is 1 day old or more
attached is a example workbook.
Excel 2003