Formula to compute percentage using variable timeframe

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.

Replay

Category: google spreadsheets Time: 2016-07-28 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 0.194 (s). 12 q(s)