NOW and WORKDAY functions

  • Thread starter Thread starter A Joy 822
  • Start date Start date
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!
 
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
 
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.
 
Back
Top