Date problems

M

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?
 
B

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)
 
M

MrEMann

Bob said:
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?
Click to expand...
 
B

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)
 
Top