Date problems

[MrEMann]

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?

 

[Bob Phillips]

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)

 

[nijunge]

I don't understand the question

what are you trying to do with the date

 

[MrEMann]

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?

 

[Bob Phillips]

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(A1>10,H1,"")

--

HTH

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