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.