Numerical Counter in Excel

[hiwire03]

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.

 

[xlstime]

Could you please attach some sample with desire results

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.

 

[Im_Offset]

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.

So in Column B, you have a list of dates, correct? Where are the "counts" you talk about?
I don't understand why you use 1/10 in one example, 10/10 in a second example, and 11/10 in a third example. Explain the logic of how you come up with that formula to use.
Lastly, what is the criteria for highlighting a particular result in RED? When does a particular result warrant the special format?
Answer those things, and perhaps people here can help you more.

 

[bosco_yip]

Maybe………

1] A1, formula :

=DATEDIF(B$1,B1,"m")+1&"/"&LEFT(TEXT(B$1,"yy"))&0

Or,

=DATEDIF(B$1,B1,"m")+1&"/"&MID(YEAR(B$1),3,1)&0

2] And, Conditional Formatting >> Select formula, enter :

=DATEDIF(B$1,B1,"m")+1>LEFT(TEXT(B$1,"yy"))*10

>> Font choose red >> OK

3] All copy down.

4] See attached file.

Regards