Welcome!

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

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!

Sales

Healthcare

Formulas

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.

thank you!

Happy to help.

help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
Formula with date column weirdness
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
TODAY Formula Constantly Changing Date to Current Date
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…