You don't use DATE in that way. If H17 is already a date, all you need is
=H17.

If you have some sort of formula, it would be something like

=IF(A110,H1,"")

--

HTH

RP
(remove nothere from the email address if mailing direct)


"MrEMann" wrote in
message ...

Bob Phillips Wrote:
Why not put the date in a cell and refer to the cell in the formula.

Changing the cell is a simple matter once a fortnight, or you could
even
automate that if there were a rule.

Thanx Bob, I thought that would be the way to go... Have tried to get
the formula =DATE(05,06,20) to work in the way tou say, eg. =DATE(H17)
but it does not work... what am I doing wrong?


--
MrEMann
------------------------------------------------------------------------
MrEMann's Profile:
http://www.excelforum.com/member.php...o&userid=26625
View this thread: http://www.excelforum.com/showthread...hreadid=399005