I am processing payment on monthly basis for employees based on per day entitlement. This entitlement changes from 91st day. So every month I get three set of employee

1. Who have already completed 90 days in previous month
2. Who would be completing 90 days in next month
3. Who is completing 90 days during the payment (current) month

I can make formula for first two but for third I need help.

I am attaching here the sample data for reference.

It is very obvious that you are in the
United Kingdom.

May I be allowed to share with you a better
presentation of dates that is very much
better for spreadsheet presentations and
also auditing of databases.

Dates are better represented as follows:-

Year = 9
Month = 02
Day = 26

DATE = 90226

In this format one can actually sort any
date in the future.

Is this what your looking for?