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...
 

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

Similar Threads

Workday Formula to include date 0
Last business day 7
Pop-up box 2
Deriving an earlier date based on a later date 7
Calculate Start Date 4
Excel Forecasting Dates Out to the Day 3
UK Business Days Formula 1
Macro?? 24

Back
Top