View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default 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