Month from a date

R

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?
 
D

Duke Carey

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
 
R

radbid

Thanks!

Duke said:
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
Click to expand...
 
R

radbid

Thanks!

Duke said:
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
Click to expand...
 
Top