View Single Post
  #1   Report Post  
Eliane
 
Posts: n/a
Default Excel running date formula minus weekend days

I have created a calendar in excel.
Row 1 shows the days of the week in text format with this formula:
=TEXT(WEEKDAY(B2),"dddd"
Row 2 shows a future date April 4, 2005 (I created running dates across the
row by clicking and dragging)
Each month is on a separate worksheet (whcih can be changed if needed).

Question: What formula can I use to create running dates (right now they are
future dates) for each month that will allow me to skip Saturday and Sunday?
I need to display weekdays only, but would like to have everything automated
so that I don't have to go in and delete the weekends for each month.

Thanks for the help!!