Date Func Question

        Date          Amount                                   Jul-18   Aug-18   Sep-18   Oct-18

       8/21/18      $25,000                                     0       $25,000     0           0

 

Fellow geeks,

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!!

Fellow Geekster

 

By: Robert Torres

Leave a Reply

Your email address will not be published. Required fields are marked *