Date minus one working day

  • Thread starter Thread starter Connie
  • Start date Start date
C

Connie

I have created a macro to insert today's date in a
worksheet when opened from a template, and to then not
update further when the saved file is opened days later.
The macro is simply =NOW() then copy, paste special,
values. What I need in the formula =NOW() is something
further so that it would subtract one business day from
the current date. So, for Monday it would insert Friday's
date. How do I go about this?
 
Thank you, Molly. That works!
-----Original Message-----
Give this one a try:

=TODAY()-CHOOSE(WEEKDAY(TODAY()),2,3,1,1,1,1,1)

Assuming you wish only the date and not date/time, I
sustituted TODAY() for NOW() ~


.
Click to expand...
 
Back
Top