Thank you CK76. I will try using this code format: EoMonth = Date.EndOfMonth(DateTime.Date(DateTime.LocalNow())) on Monday. I managed to get the PQ to update my reconciliations sheets using Jan = 1, Feb = 2 etc, but it isn't nice to look at and Accountants like dates..... I added the drop down list, and macro button to update, so pretty amazed with the power of Excel and now PQ.

Much appreciated.