Formula for pervious month
I need to construct a formula that will show the values of the last month in the history column.
Currently, the formula for OUT status is showing values for the current month : =SUMIFS([Amount after Change]:[Amount after Change], Status:Status, "OUT - to the next month", Archive:Archive, 0, [Original ETA]:[Original ETA], MONTH(@cell) = MONTH(TODAY()))
Help Article Resources
Check out the Formula Handbook template!