# Count dates last week, Mon-Fri

1. ## Count dates last week, Mon-Fri

Hello, I am in need of a formula that counts dates that fall last week, Monday through Friday. The week will always change (e.g., every Monday when I pull my data, I need to count dates from the week prior). Is this possible?

2. ## Re: Count dates last week, Mon-Fri

Yes. Assuming that you have today's date stored in A1 (i.e. =Today())

Then formula for calculating last Monday.
=A1-WEEKDAY(A1,3)-7

So formula would be something like..
Formula:
`Please Login or Register  to view this content.`

3. ## Re: Count dates last week, Mon-Fri

Thank you. So with this formula, I would need to enter in my date range each week?

4. ## Re: Count dates last week, Mon-Fri

Without knowing how your data is structured. Can't really comment on that.

I'd recommend uploading sample workbook of how your data is set up, with desensitized data and how/where you want your result to be shown.

To attach a workbook, use "Go Advanced" button found at bottom right of Quick Reply/Edit menu. Then find "Manage attachments" hyperlink and click on it. It will launch new window/tab where you can upload files.

5. ## Re: Count dates last week, Mon-Fri

I have attached the "Desen Report." I am trying to have the weekly submittals on the "RDash" tab to count from the "CanData" tab. Essentially, I will be importing the data into "CanData" tab each Monday and am looking for a formula to count the "RRtoHM Completed Date" (Col L). Thank you for all your help with this!

6. ## Re: Count dates last week, Mon-Fri

Something like below then.

If it is between Jul 9 to Jul 13.
In B1:
=DATE(2018,7,16)-WEEKDAY(DATE(2018,7,16),3)-7

Note: For your actual use replace Date() with Today(). Today() function will update to current date.
And formula used will automatically obtain date of previous week's Monday.

Then in Weekly Submittals:
=COUNTIFS(CanData!\$J:\$J,">="&\$B\$1,CanData!\$J:\$J,"<="&(\$B\$1+4),CanData!\$B:\$B, C3)

Copy to all applicable cells. See attached.

7. ## Re: Count dates last week, Mon-Fri

Thank you so much! This will make life a lot easier!

8. ## Re: Count dates last week, Mon-Fri

You are welcome

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1