This seems to work - needs more testing.
In A2 use : =(A1-1) - (WEEKDAY(A1)=1) - (WEEKDAY(A1)=2)*2
where A1 holds the starting date generated from =NOW() or =TODAY()
Copy the formula down the column (or put in B1 and copy across a row)
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"A Joy 822" <A Joy wrote in message
...
Can you combine the two? I have a workbook that about 20 people add their
work status to on a daily basis, and I would like Excel to update everyday
with a new range of workdays only.

For example, I'd start with today's date and have the past four workdays
populate new everymorning.

I used the NOW() function, and if I enter =NOW()-1, =NOW()-2, etc. it will
give me yesterday's date and the day before, but I don't want to include
Saturdays and Sundays. Thanks!