Need help..: Generate +ive & -Ive sequential number basis date Match

[Asheesh]

Guys,

Please see the attached...somehow I am not able to get it correct..

I need to match the Month and year, once it matches..put the sequential numbers if the month and mm-yy is greater than "open date"..else if it is less then put -ive sequential numbers..

Attached should explain...

 

[John Jairo V]

Hi @Asheesh

This could be an option (into B5):
=IF(ABS(COLUMNS($B5:B5)-MATCH(EOMONTH($A5,-1)+1,$B$4:$AF$4,)+1)>12,"",COLUMNS($B5:B5)-MATCH(EOMONTH($A5,-1)+1,$B$4:$AF$4,)+1)

Blessings!

 

[vletm]

@Asheesh
Press [CLng] -button to Match with Dates.