NOW and WORKDAY functions

A

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

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
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top