Bob,

When the month changes will this formula still work without me changing the
due date?

For example: If I have a due date of 7/27 when the month changes to August,
I'm I going to have to change the

Due date to 8/27?

If so, is there a way I can do this without changing the date? Maybe by
using 27 instead of the full date or having the date change automatically?

Please clarify.

Digital2k

"Bob Phillips" wrote in message
...
=AND(C2=TODAY(),C2<=TODAY()+7)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Digital2k" wrote in message
...
Hello,
I asked the following question and received help however, I have a new
twist. Instead of having the due date in column (C) I want to have the
day of the month i.e.: 17 or 27. This way I can use this for any month
without
changing the date each month.
I want to create a spreadsheet listing bills and due dates. I would like
column (A) to have the name of the bill and column (C) the have the due
date.
When the due date is a week away I would like the cell in column (A) to
change colors. I know I should use conditional formatting for this but I
need help with the formula to calculate the seven days within the due
date.