Date Amount Jul-18 Aug-18 Sep-18 Oct-18
8/21/18 $25,000 0 $25,000 0 0
I need a formula and cell formats that evaluates date 8/21/18 as MMYY and compares to other month titles (Jul, Aug, Sep) . If Date input in format of 8/21/18 is reformatted to be MMYY and equals Aug-18, then $25,000 otherwise 0…….my issue is the date formula reformats.
All help welcomed!!
By: Robert Torres