Re: $$Excel-Macros$$ Formula for Month wise calculation

Dear Mr. Paul, It great to formulate such a amazing formula to calculate such difficult scenario. Abi Joseph On Fri, Sep 29, 2017 at 5:48 PM, Paul Schreiner wrote: > This is pretty "convoluted" logic. > I tried several approaches that soon became extremely complex (as

Re: $$Excel-Macros$$ Formula for Month wise calculation

Dear Mr. Paul, Thanks :) *Regards,* *For quick responds click here for Message * On Fri, Sep 29, 2017 at 3:18 PM, Paul Schreiner wrote: > This is pretty "convoluted" logic. > I tried several approaches that soon became extremely complex (as

Re: $$Excel-Macros$$ Formula for Month wise calculation

This is pretty "convoluted" logic.I tried several approaches that soon became extremely complex (as if this isn't?) The approach is this:Establish a starting date of 01-Jan of LAST yearand an Ending Date of -1-Jan of NEXT year.(I could've hard-coded these dates, but then you'd have to edit the

$$Excel-Macros$$ Formula for Month wise calculation

Hi All, Request to all of you that kindly find the attached sheet and help me to calculate Month wise cost by selecting the month and how to represent the same in piot table too. your assistance in this regards will be highly appreciated Thank you *Regards,* *Vikhen* -- Are you =EXP(E:RT)