excluding my country's weekends
hey i just did this the other day
i did it in 2 steps
first step: create a list of dates excluding weekends going down a column
cell A1 = today()
cell A2 = IF(WEEKDAY(a1+1)=1,a1+2,IF(WEEKDAY(a1+1)=7,a1+3,a1 +1))
cells A3:500 = extend the formula downwards a long way
second step: build the bit which works it out
cell B1 = (your date)
cell B2 = (how many dates to add)
cell B3 = index(A1:A500,match(B1,A1:A500,0)+B2,1)
I suppose you could get this to work in one step if you can be bothered to
think about it but I can't.
--
Allllen
"Karam" wrote:
I have a start date in cell A1 ( 10/05/2007 ) ,specific number in cell b1 ( 5
) then i need to caculate the due date which equals A1+A2 excluding the
weekends noting that my coutry's weekends are ( friday & saturday ).
i ll be so grateful if any body helps me.
Thanks
Karam
|