P Porwal P K Jun 27, 2008 #1 In fill series date : I want to work on weekdays. I want weekly off as Thursday
T T. Valko Jun 27, 2008 #2 If you want to fill a series of dates and exclude Thursdays: Enter the starting date in your first cell, assume A1: A1 = 7/1/2008 Enter this formula in A2 and copy down as needed: =A1+CHOOSE(WEEKDAY(A1),1,1,1,2,1,1,1)
If you want to fill a series of dates and exclude Thursdays: Enter the starting date in your first cell, assume A1: A1 = 7/1/2008 Enter this formula in A2 and copy down as needed: =A1+CHOOSE(WEEKDAY(A1),1,1,1,2,1,1,1)
