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!

Register Yourself Login