Numerical Counter in Excel

  • Could anyone help me writing a formula for this logic?

    When formula typed in cell A1=Some logic declaring a particular mmm.yy (say Jul 16) and the number of counts "y" (say 10)
    then, Displayed in cell A1= 1/10

    when cell B2 contains Apr 17
    then, Displayed in cell A2= 10/10

    when cell B2 contains May 17
    then, Displayed in cell A2= 11/10 highlighted in RED

    Thanks in advance.

  • Re: Numerical Counter in Excel

    MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!