Because of that i created a pretty cool spreadsheet that i showed my manager today and she loved it. Your response had a direct impact in my job performance and will make our operations more efficient. Te debo una cerveza cuando vengas a Connecticut.
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?