I was wondering is somebody could help me with this problem, I have a spreadsheet like the one below.

I need a cell to equal the next payment number if the date is between to dates. So for example if today was the 20th January then the cell b2 would be 3 as the 1st Feb is the next payment number.

I was able to highlight a cell with conditional formatting for the next payment date, but this time I want cell b2 = the next payment number based on todays date.

Does anyone know the best way to achieve this
[![Excel](https://i.stack.imgur.com/ReQxF.png)](https://i.stack.imgur.com/ReQxF.png)

Thanks in advance

David :)