Date Range Syntax (Previous Week, Previous Month)

[Gerald42]

Hello all

I'm trying to return two separate date ranges. One is basically last week. ie, last Monday through Last Sunday..

The other is the Last Month, ie. July 1st to July 31st

I'm trying to have this dynamic, so it will calculate these any days...Any suggestions?

Thanks in advance for any input!

 

[al_b_cnu]

Hi,

Last week: =TODAY()-7
Last month: =DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(TODAY()))