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.

=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.

Thank you Bob!

"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.

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.

Do you mean that you want to assume the today's month regardless of what
date is in the cell, and test using a 'made-up date?

--
HTH

Bob Phillips

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

"Digital2k" wrote in message
...
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.

Yes, Please show me the best way to handle this.
Thank You!
Digital2k

"Bob Phillips" wrote in message
...
Do you mean that you want to assume the today's month regardless of what
date is in the cell, and test using a 'made-up date?

--
HTH

Bob Phillips

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

"Digital2k" wrote in message
...
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.

Try this

=AND(DATE(YEAR(C2),MONTH(TODAY()),DAY(C2))=TODAY( ),DATE(YEAR(C2),MONTH(TODA
Y()),DAY(C2))<=TODAY()+7)

--
HTH

Bob Phillips

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

"Digital2k" wrote in message
...
Yes, Please show me the best way to handle this.
Thank You!
Digital2k

"Bob Phillips" wrote in message
...
Do you mean that you want to assume the today's month regardless of what
date is in the cell, and test using a 'made-up date?

--
HTH

Bob Phillips

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

"Digital2k" wrote in message
...
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.