G Guest May 23, 2004 #1 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?
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 May 23, 2004 #2 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?
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 May 23, 2004 #3 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)
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)
