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.