Formula help - trying to sum a column if launch date is in the next 30 days

MWester

Hello,

I'm trying to sum numbers in a column a if the launch date is within the next 30 days. Thanks in advance for any help!

Paul Newcome

Try something along the lines of...

 

=SUMIFS([Column A]:[Column A], [Date Column]:[Date Column], AND(@cell >= TODAY(), @cell <= TODAY(30)))

 

It will sum column A if the date is between today and the next 30 days.

MWester

thank you!

Paul Newcome

 Happy to help.