title: Excel display nth day of current month
body: <p>I have a list of recurring bills. Some are on the 1st of every month, and some are on the 15th or 16th etc. What I want to be able to do is display this day within the current month. So if it is February, and the bill recurs on the 9th every month, my cell will show 02/09/12, and if it was march, it would show 03/09/12. Is there a formula or macro to accomplish this?</p>