NOW and WORKDAY functions
 

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!

NOW and WORKDAY functions
 

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!

NOW and WORKDAY functions
 

Just use

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

and copy across

--
__________________________________
HTH

Bob

"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!

NOW and WORKDAY functions
 

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.

--
Biff
Microsoft Excel MVP


"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!