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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to implement two shifts per day with multiple teams 0
Search closest day in the past from today 2
Does date in Cell A1 occur between the date in M1 and Date in X1 1
Future date with six day week including holidays 1
Using project as a resource tracker 0
No of Days between two dates and offset formula 4
Calculate the number of days to exclude Sunday & Holidays 6
How to calculate difference between two date & time along with working hours and days 2

Top