Date minus one working day

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?
 
C

Connie

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

Search closest day in the past from today 2
Autofill Date in Word 15.33 for Mac 0
Mail Merge skipping records/sending one at a time 0
Set as Default Template not working 0
List all tables, including document structure 0
Remote stopped working in PowerPoint Presenter View 0
Getting Radio Buttons to work, that are inserted via AutoText 0
Testing a cell value for a specific weekday. 4

Top