If A1 is a given date in the past mm/dd/yyyy
I want B2 to show CURRENT Month and Year but the day from A1
For example if today is 11/6/2012 (NOVEMBER,2012)
A1=5/28/2011
B2= 11/28/2012 (NOVEMBER, 2012) and the 28 comes from A1
What formula would you enter in B2?