Month from a date

[radbid]

I'm trying to keep track of unpaid invoices that are at least one month old.
I have a column of dates. If today's date is at least one calendar month
greater than the date, Excel should "flag" this item somehow. Ideally, it
should also copy those items to another worksheet. Any ideas?

 

[Ardus Petus]

Have a look at Data>Filter>Advanced filter

Regards,

 

[Guest]

You can use conditional formatting to 'flag' an item.

Let's say the data occupies columns A thru E and the dates are in column A.
Select the data range and take note of what cell is active. Assume it is A2.

Go to Format>Conditional formatting... and select Formula is and enter
=$A2<DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

Click on the Format button and select the formatting that will sufficiently
'flag' the item for you

 

[radbid]

Thanks!

You can use conditional formatting to 'flag' an item.

Let's say the data occupies columns A thru E and the dates are in column A.
Select the data range and take note of what cell is active. Assume it is A2.

Go to Format>Conditional formatting... and select Formula is and enter
=$A2<DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

Click on the Format button and select the formatting that will sufficiently
'flag' the item for you

 

[radbid]

Thanks!

You can use conditional formatting to 'flag' an item.

Let's say the data occupies columns A thru E and the dates are in column A.
Select the data range and take note of what cell is active. Assume it is A2.

Go to Format>Conditional formatting... and select Formula is and enter
=$A2<DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))

Click on the Format button and select the formatting that will sufficiently
'flag' the item for you