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

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies