# Thread: Count based on today day condition

1. ## Count based on today day condition

Hello!

I am new to this forum & excel as well. Any help from fellow members would be greatly appreciated. My situation is:

I need to prepare a weekly excel report on every Monday. But there is a scenario that if i need to prepare this report suppose on Wednesday then how am i going to do it since i need to consider dates of last week only (i.e. till Sunday) & not the current week.

So to elaborate, there is an excel in which there is a sheet in which 1 column contains some dates. In 2nd sheet, i need to count only those cells which has dates of previous weeks. If today is Monday then it is very easy i have used the formula:

=COUNTIF(Data!\$AA\$2:\$AA\$48,">"&TODAY()-7)+COUNTIF(Data!\$AA\$2:\$AA\$48,"="&TODAY()-7)

considering that today is Monday. But in case today is Wednesday then how should i proceed please provide me your guidance.

Amit

2. Try replacing TODAY() with TODAY()-WEEKDAY(TODAY(),3)

#### Posting Permissions

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