Schedule Help in Excel

[dkgolfer39]

Hi,

I've been working on this for a couple of days and I'm not sure if Excel can do what I'm trying to make it do. Any help would be greatly appreciated. The problem is explained below.

Column A = Value (2 or 5 or 4 for example). I want excel to read this as a week. So for example A1 would have value 3 but excel would recognize it as 3 weeks.

Column B = Date (12/11/09 for example)

Column C = Due Date. So if A1 had 3, B1 had 12/11/09, C1 would automatically say C1 = 11/20/09 (3 weeks prior to 12/11/09).

Column D = Today's date. If Column D is a later date then Column C (So if it is 11/22/09) than the entire row automatically highlights (Conditional Format).

Thanks for all the help. I've trying for a while but to no avail.

[JBeaucaire]

Any chance what you meant was:

A = Weeks
B = Due date (entered manually)
C = Start Date (formula needed)

In C2, try: =B2-(A2*7)

Highlight all three cells (or a bunch of rows to do this all at once) and activate the Conditional Formatting window. Use these parameters:

Condition1: Formula Is: =TODAY()>$B2
Format... Patterns... Yellow

NOTE: You don't actually have to enter today's date into a cell to use the date in a CF formula. You can just use the TODAY() function and it works the same.

[dkgolfer39]

Any chance what you meant was:

A = Weeks
B = Due date (entered manually)
C = Start Date (formula needed)

In C2, try: =B2-(A2*7)

Highlight all three cells (or a bunch of rows to do this all at once) and activate the Conditional Formatting window. Use these parameters:

Condition1: Formula Is: =TODAY()>$B2
Format... Patterns... Yellow

NOTE: You don't actually have to enter today's date into a cell to use the date in a CF formula. You can just use the TODAY() function and it works the same.

Awesome! Thank's a lot.

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)