amit_singhal
New member
- Joined
- Sep 2, 2015
- Messages
- 1
- Reaction score
- 0
- Points
- 0
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.
Thanks in advance !
Amit
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.
Thanks in advance !
Amit