Setting criteria between two dates (advanced filter)
I have a long column of dates that I need to now when they are about to expire (1 month before)
I am very new to excel and want the dates to be moved to a new column when they are within a month of the expiry date.
I have been playing around with advanced filter using just numbers, and it's worked for me. But I can not seem to do it using a month criteria/conditon.
Furthermore I want it to be able to tell me what it is that is expiring. e.g
A1-100 is the names of people.
B1-100 is the expiry date
In short: I want excel to start a new column and add the name of the person that is about to 'expire' a month before.
Mod. edit: thread moved from Outlook forum to Excel General forum
Last edited by DonkeyOte; 02-08-2011 at 04:12 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1