Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Creating a formula
I would like to know how to enter a fomula that would automatically update
multiple columns when I change a column amount. I have 3 columns set up Start Date Finish Date # of Weeks I would like the Start Date to automatically update when I input the # of weeks to completion. I can not seem to get it to work because it is making a reference to itself. I hope this makes sense to someone out there. |
#2
|
|||
|
|||
You need 2 out of 3 of the factors to be known
Start Date = Finish Date - (7 x # of Weeks) Finish Date = Start Date + (7 x # of Weeks) # of Weeks = (Finish Date - Start Date)/7 HTH, Gary Brown "monicaa" wrote in message ... I would like to know how to enter a fomula that would automatically update multiple columns when I change a column amount. I have 3 columns set up Start Date Finish Date # of Weeks I would like the Start Date to automatically update when I input the # of weeks to completion. I can not seem to get it to work because it is making a reference to itself. I hope this makes sense to someone out there. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Formula using check boxes | Excel Discussion (Misc queries) | |||
HELP creating what should be easy formula! | Excel Worksheet Functions | |||
HELP creating formula! | Excel Worksheet Functions | |||
Creating a formula that references other sheets | Excel Worksheet Functions | |||
Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions |