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.

--

HTH

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


"MrEMann" wrote in
message ...

I use a worksheet as my subcontractors invoice. the date formulars work
fine, though at the moment I change the date within the formular for
each new fortnight.
Is there a way I can get a pop up prompt or similar where I just type
in the date to activate the formular?


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