Date formula
=IF(A1,A1+4,"")
Will Emms wrote:
Hi there,
That's great. Now do you have any idea how I can hide the values the formula
is generating when the original date cell is blank or zero?
Cheers,
Will
"Will Emms" wrote:
Hi there,
I want to set up a formula so that when I enter a date in one cell the cell
with the formula gives me a date 4 days in advance.
Any ideas?
Many thanks,
Will
|