Solved

%3CLINGO-SUB%20id%3D%22lingo-sub-2216092%22%20slang%3D%22en-US%22%3ENeed%20help%20formulating%20crop%20planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2216092%22%20slang%3D%22en-US%22%3ESo%20I%E2%80%99m%20creating%20a%20crop%20planner.%20In%20the%20%E2%80%9CCrop%20Actions%E2%80%9D%20area%20I%20have%20it%20set%20so%20(P6%3AP24)%20generate%20the%20common%20crops%20that%20customers%20have%20purchased%20in%20a%20given%20week.%20Once%20populated%20however%20I%20want%20to%20figure%20the%20formulas%20for%20%E2%80%9Csoak%20date%E2%80%9D%2C%20%E2%80%9Csow%20date%E2%80%9D%20and%20%E2%80%9Cuncover%20date%E2%80%9D%20to%20populate%20for%20each%20crop%20by%20taking%20the%20date%20of%20the%20harvest%20day%20which%20in%20text%20is%20%E2%80%9C44200%E2%80%9D%20and%20subtracting%20a%20day%20for%20the%20crops%20that%20require%20a%20soak%20and%20not%20subbing%20a%20day%20when%20a%20crop%20doesn%E2%80%99t%20require%20a%20soak.%20With%20that%20the%20other%20two%20values%20should%20be%20figured.%3CBR%20%2F%3EBut%20with%20each%20crop%20having%20the%20possibility%20of%20being%20different%20I%20believe%20there%20is%20a%20long%20string%20of%20functions%20I%20require%20but%20I%20can%E2%80%99t%20seem%20to%20put%20them%20together.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20thoughts%20would%20be%20appreciated.%20Sorry%20for%20lack%20of%20info.%20Been%20racking%20my%20brain%20trying%20to%20figure%20this%20formula%20and%20this%20is%20a%20spur%20of%20the%20moment%20post.%20TIA%3CBR%20%2F%3E%3CBR%20%2F%3EAlso%20I%E2%80%99m%20using%20a%20Mac%20so%20I%E2%80%99m%20unable%20to%20use%20xAction%20and%2For%20most%20developer%20tab%20tools%20and%20macros%20I%E2%80%99m%20pretty%20sure.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2216092%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2216263%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20formulating%20crop%20planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2216263%22%20slang%3D%22en-US%22%3EHonestly%20I'm%20unable%20to%20co-related%20the%20data%20you%20have%20provided%20through%20image%20file%2C%2C%2C%20as%20you%20have%20written%20that%20you%20want%20to%20find%20SOAK%2C%20SAW%20%26amp%3B%20UNCOVER%20dated%2C%20what%20I%20guess%20is%20all%20you%20need%20to%20find%20difference%20between%20dates%20or%20may%20be%20the%20date%20you%20want%20to%20SOAK%2C%20SAW%20%26amp%3B%20UNCOVER%20%2C%2C%20for%20all%20these%20a%20mechanism%20is%20required%20that%20you%20have%20to%20show%20us%20must%20be%20the%20pattern%20in%20terms%20of%20dates%20like%20date%20on%20the%20crop%20SOAK%20and%20next%20SAW%20and%20how%20days%20should%20be%20counted%20in%20between%2C%2C%2C%20whether%20are%20depends%20on%20Croup%20Type%20and%20others!!%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Contributor
Solved
1 Reply
Honestly I'm unable to co-related the data you have provided through image file,,, as you have written that you want to find SOAK, SAW & UNCOVER dated, what I guess is all you need to find difference between dates or may be the date you want to SOAK, SAW & UNCOVER ,, for all these a mechanism is required that you have to show us must be the pattern in terms of dates like date on the crop SOAK and next SAW and how days should be counted in between,,, whether are depends on Croup Type and others!!