+ Reply to Thread
Results 1 to 1 of 1

Setting criteria between two dates (advanced filter)

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2003

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1