Need a formula for month only

Question

Good day, I am attempting to use one column to do 2 different functions I think. So I'm coming to the experts 🙂

OK, so I need a column that is a date (Ex., A2= 06/07/2023). It should be a date because elsewhere this is used to calculate -90 days.

Here's the rub: in ANOTHER place I need this to be added to all the other totals from that month (June in this case) ONLY. AND this needs to not be affected by year as this will be a rolling totals and each year will have different numbers.

I might be going about this wrong (in fact I'm sure of it) so I included a simplified workbook with the blocks and layout I'm going for. Thanks again for any and all help!

hansvogelaar · Answer

Scholtar&nbsp;
Sheet1 has some rows with 2022 in the Year column, but a date in 2023 in the Day/Month column. Is that intentional? If so, how should we treat those dates?

sergeibaklan · Answer

Scholtar&nbsp;
Perhaps
=SUMIFS(
    Sheet1!$C$3:$C$7,
    Sheet1!$B$3:$B$7, "&lt;=" &amp; EOMONTH(DATE(B$2, MONTH(1 &amp; $A3), 1), 0),
    Sheet1!$B$3:$B$7, "&gt;=" &amp; EOMONTH(DATE(B$2, MONTH(1 &amp; $A3), 1), 0) - 90
)
if to enter days as full ones

&nbsp;

scholtar · Answer

That was not intentional, but as I didn't manually put in the year it makes sense that it autofills it. This could be the start of where I'm going wrong. If I fix that then what should the next part to auto-sort on sheet2 be?

hansvogelaar · Answer

Scholtar&nbsp;
See the reply by SergeiBaklan&nbsp;

Forum Discussion

Need a formula for month only

Share

Resources