last week

I have a very large excel file that I create every Monday. Many of these tabs have where i am looking at current week and last weeks information. For last week I am looking up from last weeks file. This is a very manual and slow process to have to go change the date for last week each week. Is...

I'm trying to come up with a TRUE/FALSE formula to check if a date is within last week. I thought this would be quite simple but that's not the case (at least for me). I have come up with a formula that checks if today's date is within the current week and year - and that works perfectly fine...

Hello, I would like to count the number of rows where the column H match the value of my column B3, the closed date (column G) is not empty, and the closed date (column G) is greater than today minus 7 days (e.g. older than a week) I've tried this one ... but - of course - it failed...

I need to run a report that could be run at anytime after the weeks end. The report needs to look at only the previous week. I can easily look at the last 5 days but if I run the report on a Wednesday it will just look back 5 days and not take in the previous week. Any ideas out there in Excel...