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)
 
Back
Top