Home

Date/Weight selection formula

%3CLINGO-SUB%20id%3D%22lingo-sub-714049%22%20slang%3D%22en-US%22%3EDate%2FWeight%20selection%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-714049%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20with%20the%20following%20columns%3A%3C%2FP%3E%3CP%3EA%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20B%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BC%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BD%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20E%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20F%3C%2FP%3E%3CP%3EDate%26nbsp%3B%20%26nbsp%3B%20Weight%26nbsp%3B%20%26nbsp%3BDays%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B30%20Day%26nbsp%3B%20%26nbsp%3B90%20Day%26nbsp%3B%20%26nbsp%3B%20180%20Day%3C%2FP%3E%3CP%3EProgram%20uses%20C%20Days%26nbsp%3B%20%22IF(A4%3D%22%22%2C%22%22%2CDAYS(A4%2C%24A%243))%22%20to%20determine%20days%20lapsed%20for%20each%20date%20of%20weight.%3C%2FP%3E%3CP%3EAfter%2030%20days%20have%20lapsed%2C%20formula%20needs%20to%20go%20back%20rolling%2030%20days%20(or%20closest%20date%20to%2030)%20from%20current%20weight%20and%20calculate%20%25gain%20or%20loss.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%20days(looking%20for%20end%20date%2Cbegin%20date)%20how%20do%20I%20modify%20formula%20to%20subtract%2030%20from%20end%20date%20and%20select%20that%20weight%3F%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20assistance%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-714049%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
bubby70
Established Member

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