Hi I'm wondering if it is possible to use the DATESBETWEEN function using dates from 2 cells.
I would like to run my inventory as of a date last year.
I will be taking the current on hand, + units sold today to last year, - units received since start date.
I would like to have a cell that the formula grabs as the start date to go back to.
UNITS SOLD LAST YEAR:=CALCULATE('tblInvSkuMaster'[SALES TOTAL UNITS SOLD],DATESBETWEEN(dCalendar[DATES],TODAY()-366,TODAY()))
Thanks
I would like to run my inventory as of a date last year.
I will be taking the current on hand, + units sold today to last year, - units received since start date.
I would like to have a cell that the formula grabs as the start date to go back to.
UNITS SOLD LAST YEAR:=CALCULATE('tblInvSkuMaster'[SALES TOTAL UNITS SOLD],DATESBETWEEN(dCalendar[DATES],TODAY()-366,TODAY()))
Thanks