If a cell has a specific value I want to format another cell for them to
enter a date. If it has a differnt value, I would like to automatically fill
in n/a for the date. For instance if their answer is Y then I want a date
format for the cell, if the answer is N then I want N/A to automatically be
put into the cell.

Put in the formula

=If(Cell1="Y",Cell2,"N/A")

Put in the appropriate cells for Cell1 and Cell2

Im assuming cell2 is the date

"Sue" wrote:

If a cell has a specific value I want to format another cell for them to
enter a date. If it has a differnt value, I would like to automatically fill
in n/a for the date. For instance if their answer is Y then I want a date
format for the cell, if the answer is N then I want N/A to automatically be
put into the cell.