Roman F
asked on
how to use Function Now ()-1 in Sumifs function
I have an Excel formula;
=SUMIFS(InputData!$h$2:$h$ 999,InputD ata!$C$2:$ C$999,"New Application",InputData!$L$ 2:$L$999," =")
sum all numbers from column H where category (column C)=New Application for all dates from column L
it is working fine
I want to modify the sentence and use the function (Now()-1: InputData!$L$2:$L$999 should be the yesterday date
=SUMIFS(InputData!$h$2:$h$
sum all numbers from column H where category (column C)=New Application for all dates from column L
it is working fine
I want to modify the sentence and use the function (Now()-1: InputData!$L$2:$L$999 should be the yesterday date
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you for your help
You're welcome!
TODAY() function only gives the date; as per solution above.