Date formula
 

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

Date formula
 

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)


"Will Emms" wrote in message
...
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

Date formula
 

=c1 +4
will work after you format the cell

"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

Date formula
 

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

Date formula
 

"Will Emms" wrote in message
...
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

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

Regards.

Bill Ridgeway
Computer Solutions

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