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