Calling all Excel Guru...AGAIN!

IHAVEAQUESTION

Golden Member
Nov 30, 2005
1,061
3
81
Alright, this time I made a file so you guys can see what I want to achieve:

https://onedrive.live.com/redir?resid=E18117CDA154C70!12160

So there are two tabs in this workbook. On the "Good" tab, the dates are converted to the first of the month. So for instance, 3/13/14 on the "Date" column will be 3/01/14 on the "MM/YY" column.

On the "Bad" tab however, the "MM/YY" looks the same as in the "Good" tab but still retains the same date value as in "Date" column. SO for instance, 3/13/14 on "date" is still 3/13/14 on "MM/YY".

The MM/YY on the "good" tab is the result I want. I did it once...remember it involved pasting to a clipboard but forgot how to do it again. Can anyone enlighten me? thank you.
 

Edgy

Senior member
Sep 21, 2000
366
20
81
=DATE(YEAR(A3),MONTH(A3),1)

Where A3 would be the cell for original date - this formula would take the year and month from A3 and assign the date to be "1" (first date of that month).