I'm working on this spreadsheet: https://docs.google.com/spreadsheets/d/14fo-BAM7qhyYr39D0i4Lr0zIit5bqYfpoWcIvLjWX9s/edit#gid=1354673218
I need to create a function for measuring the booked appointment (ie, column F, Booked Lead) rate from the last 30 days across all countries.
What's the best way to do this? I can only come up with a formula using constant values but not with variable timeframe. Thanks for any help.