Date formula

W

Will Emms

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
 
P

Peo Sjoblom

Just add 4 to it

=A1+4

if you mean business days

=WORKDAY(A1,4,Holidays)


where Holidays can be a range with public holidays


--


Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
(Remove ^^ from email)
 
W

Will Emms

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
 
B

Bill Ridgeway

Will Emms said:
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
Click to expand...

=IF(C4="","",C4+1)

Regards.

Bill Ridgeway
Computer Solutions
 
B

Bob I

=IF(A1,A1+4,"")

Will said:
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

:
Click to expand...
 
Top