Jun 21 2019 08:52 AM
I have a table with the following columns:
A B C D E F
Date Weight Days 30 Day 90 Day 180 Day
Program uses C Days "IF(A4="","",DAYS(A4,$A$3))" to determine days lapsed for each date of weight.
After 30 days have lapsed, formula needs to go back rolling 30 days (or closest date to 30) from current weight and calculate %gain or loss.
Formula days(looking for end date,begin date) how do I modify formula to subtract 30 from end date and select that weight?
Thank you for your assistance