Hello,

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.