Please can someone tell me if ther is a way (formula or macro) that I could
use to return a specific date (i.e 5th of Month - and year - e.g 5/10/06) for
any dates input in another cell

That is to say if I type 4/10/06 in one cell I can get a value of 5/10/06 in
the destiantion cell and if i input 6/11/06 in my cell i need to get value of
5/12/06 in my destination cell (working with UK date format).

Any help appreciated