TODAY function

  • Thread starter Thread starter cris
  • Start date Start date
C

cris

hi - it has been a while since i've used the functions in
excel... i cannot remember how to create the function that
takes today's date (whatever "today" happens to be) and
caluclates 7 days prior, or 6 days prior or whatever i
want it to... i want to be able to open the spreadsheet
every monday and have the report list the dates of the
previous monday - sunday... anybody with me on what i'm
trying to explain? can anybody nudge my memory a bit?
thanks for the help in advance...
 
What you asked:

=TODAY()-7

What you probably want (previous Monday):

=TODAY()-CHOOSE(WEEKDAY(A1),13,7,8,9,10,11,12)
 
You must log in or register to reply here.

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

Conditionally Format Particular Dates 1
Display yesterday's date but only for weekdays? 7
Saving TODAY function to keep the date accurate. (when it was done) 2
Conditional Formatting to Exclude Weekends 4
IF function 4
need help writing function 9
Finding the right function & formula 4
Last business day 7

Back
Top