NOW and WORKDAY functions

[A Joy 822]

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!

 

[Bernard Liengme]

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

 

[Bob Phillips]

Just use

A1: = TODAY()
B1: =WORKDAY(A1,-1)

and copy across

 

[T. Valko]

Yeah, you can use the two combined.

=WORKDAY(NOW(),-1)

Format as Date

NOW() returns both the date and current time but WORKDAY just truncates the
time portion.