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.

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.

--
Gary''s Student - gsnu200768


"Leslie" wrote:

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.

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

"Gary''s Student" wrote:

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.

--
Gary''s Student - gsnu200768


"Leslie" wrote:

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.