Adding 3 days to a date

F

FUNPIX

This may be simple but baffling to me. How do I write a formula to show three days advanced from todays day, jumping over a sunday or holiday?
 
P

Peo Sjoblom

Look at WORKDAY

=WORKDAY(A1,3)

note that you have to install ATP to get this function,
under tools>add-ins

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom

FUNPIX said:
This may be simple but baffling to me. How do I write a formula to show
Click to expand...
three days advanced from todays day, jumping over a sunday or holiday?
 
B

Bob Phillips

If you want to skip holidays, you need to extend Peo's answer.

Create a range with the holiday dates in it, say H1:H12, and then use

=WORKDAY(A1,3,H1:H10)

H1:H10 could be a named range.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top