I need a couple things here, but I think they may be similar formulas:

I have a list of dates in an Excel file (Column A). I'd like to create a 2nd list (Column B) that will have a formula that will return the **nearest previous** (most recent) 25th day of the month of the corresponding cell in Column A.
If the date falls exactly on the 25th,
I need the result to keep that same date.

So for example:

- If A1 has the date of 3/14/16, B1 will return 2/25/16.
- If A2 has the date of 5/28/16, B2 will return 5/25/16.
- If A3 has the date of 5/25/16, B3 will return 5/25/16.

I also need a formula that will return the **next** 25th of the month.

For example:

- If A1 has the date of 3/14/16, B1 will return 3/25/16.
- If A2 has the date of 5/28/16, B2 will return 6/25/16.
- If A3 has the date of 5/25/16, B3 will return 6/25/16.