Sep 03 2022 03:25 AM
I have a large amount of data that was generated over a period of 4 months equivalent to 10 weeks, recorded in days and time. How do I formulate my cell to break the data into weeks, then filter the data into 10 weeks?
Sep 03 2022 04:37 AM
To display date in calendar week you can use the formula: =WEEKNUM(A4) in D4.
This article describes the formula syntax and usage of the WEEKNUM function in Microsoft Excel.
After that, you could add up the calendar week with a simple sum.
Here is a small example of the formula: =SUMIF(D4:D35,D4,E:AA)
Hope I was able to help you with this info.
I know I don't know anything (Socrates)
Sep 09 2022 02:55 AM
@NikolinoDE thank you, but I think I did not explain properly what I actually need help in. The first screen shot picture that I shared is exactly what you had explained. What I am having a challenge with is how to use xIfn and UNIQUE properly, after getting the number of weeks, how do I filter the data further?
Sep 09 2022 06:33 AM
Sep 09 2022 10:13 AM
@Patrick2788 thank you so much, I am trying the pivot suggestion right now. My computer has Excel 2019.
This is the section, I am struggling with