Automatic Date Updates (excluding weekends)

I am confused by your language. Columns are vertical,... rows are horizontal. So i don't understand "Column A has the date of the month going across the row. "

So... Will you please attach a SMALL sample Excel workbook (10-20 rows of data is usually enough)? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution is also shown (mock up the results manually).

3. Make sure that all confidential information is removed first!!

4. Try to avoid using merged cells. They cause lots of problems!

Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

In the attached workbook cell B1 of the 'Jan' sheet establishes the first weekday of the year using the formula:

Formula:

Please Login or Register  to view this content.

On the 'DailyAdds_Scrubs' sheet cell B1 references the previous value and establishes the first weekday of April using the formula:

Formula:

Please Login or Register  to view this content.

Note that the '4' in the April formula denotes the month number and will need to be changed for each of the months, i.e. Feb = 2 etc.
The remaining weekdays for the month of April are displayed using the following formula which is copied to each 5th cell in row one:

Formula:

Please Login or Register  to view this content.

Sheet 1 is just a test sheet, however I decided to leave it so as to check the weekdays of the various months.
Let us know if you have any questions.

Hi. I didn't seem to get a notification when you posted your sheet. However, here's one possible way.

Enter the start date (in full) in A1. In F1, enter this formula:

=IFERROR(OFFSET($A$1,,IF(MOD((COLUMNS($F:F)-1),5)=0,5*INT((COLUMNS($F:F)-1)/5),""),,)+CHOOSE(WEEKDAY(A1+1),2,1,1,1,1,1,3),"")

then copy across. It increments by one working day every 5th column. The intervening cells asre blank.