Ranking based on criteria

Originally Posted by wk9128

Hi andrei461 , you post at #8 , F7 should be 1 right ? but your result is blank
F4 cell formula

HTML Code: 

Thanks wk9128 for your response.
As i was testing ur formula its doing what i intend but the rank is skipping "1", its starting as 0, 2, 3 and so on also ur formula does not take account of the date criteria. just check the sheet i have attached.

Thanks for your help

Note : Col. E has your formula Whereas Col. F has my desired rank