sum if
1 Topic
Sum if date is within last 7 calendar days of month
Hi, I need to calculate the sum of the # of invoices, but only if the Date is in the last 7 calendar days of each month. I will have YTD data, updated daily. # invoices Date 7 6/27/2023 4 6/28/2023 2 6/29/2023 1 7/21/2023 2 7/22/2023 4 7/27/2023 5 7/28/2023 2 7/29/2023 3 7/31/2023 I thought about trying to create a column with "true" if it is in the last 7 days, and "false" if not. But I don't know how to write that. Anyone have ideas?Solved1.1KViews0likes4Comments