Forum Discussion

Scholtar's avatar
Scholtar
Copper Contributor
Jun 12, 2023

Need a formula for month only

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 b...
excel
Formulas and Functions
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Jun 12, 2023

Scholtar 

Perhaps

=SUMIFS(
    Sheet1!$C$3:$C$7,
    Sheet1!$B$3:$B$7, "<=" & EOMONTH(DATE(B$2, MONTH(1 & $A3), 1), 0),
    Sheet1!$B$3:$B$7, ">=" & EOMONTH(DATE(B$2, MONTH(1 & $A3), 1), 0) - 90
)

if to enter days as full ones

 

Resources