Could you suggest a formula to look at the value of one cell and, if the
value of that cell is 00/00/0000 (a cell formated as a date field), look at
the value of another cell and make a calculation?

I posted this previously, but was not specific about the 00/00/0000 cell value

Thanks.

try

=IF(CELL("format",A1)="D4", Value If TRUE, Value If FALSE)

or if you're looking for any date format, I think you would use:

=IF(OR(CELL("format",A1)={"D1","D2","D3","D4","D5" }), Value If TRUE, Value
If FALSE)

check Excel help for the CELL function for more details.


"sdmccabe" wrote:

Could you suggest a formula to look at the value of one cell and, if the
value of that cell is 00/00/0000 (a cell formated as a date field), look at
the value of another cell and make a calculation?

I posted this previously, but was not specific about the 00/00/0000 cell value

Thanks.