Results 1 to 2 of 2

Thread: Count based on today day condition

  1. #1

    Count based on today day condition



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,508
    Articles
    0
    Excel Version
    Excel 2016
    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
  •