Formula for Revenue by week and month

TPALJA

Im trying to determine the revenue by week and by month using the completed date field

Andy Taylor

in short, Helper Columns

Create additional columns that 'see' whether a date falls between two dates, whether that is a certain week, month, quarter, or year. you can use and =IF( statement, where if it is true, then =1, if not =0

THEN

Leverage a Sumifs statement which will add the revenue if the appropriate helper column is true, =1.