Help with a formula, please

L

Leslie

I'm working on a Project Summary workbook, containing a "Dashboard" sheet
(which displays a snapshot of the most recent project data), and 4 other
sheets: Project Scope, Project Status, Project Change and Project Closure.
The Project Manager wants to enter the "Approved Finish Date" into cell A on
the Dashboard page at the start of the project, but if this date changes, the
PM will enter the changed Approved Finish Date into cell B on the Project
Change sheet. I need your help to write a formula that allows the PM to hard
key a date into cell A, and still allows cell A to pull data from cell B to
replace the hard keyed data in cell A. Is this function possible? If yes,
please help me with the formula.
 
G

Gary''s Student

Use three cells:

In cell B, enter the hard coded date
In cell C, the PM enters an override data if desired
In cell A enter:

=IF(C1="",B1,C1)

So if there is no override, B is displayed.
 
L

Leslie

Thank you very much for taking the time to reply, Gary. Your formula
suggestion has my form functioning as I hoped it would. Thank you again!
Leslie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top