View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
MMangen MMangen is offline
external usenet poster
 
Posts: 26
Default Desire Weekday returned in every 5th Cell

I have a worksheet with Monday, March 15, 2010 in Cell A2.

I'd like to have a formula that will put Tuesday, March 16, 2010 in the
fifth cell after that (in this case Cell A7) and so on......I do not want
Saturdays/Sundays to show up.

Any idea if this can be done and if so, with what formula?