Good day everyone,
I'm trying to find a way to look up a field from 1 year ago (ex: Daily sales) and have it auto-enter on the new record. But I need the formula to compare it to the same day of the week of the previous year i.e. Saturday to Saturday.
For example I would want to fetch the value from Thursday, October 12th, 2017 and auto-enter to the new record that is created on Thursday, October 11th, 2018.
Will this solution account for leap years?
Thanks so much!!!