Hi,
I have a column with months (mm) and a column with years(yyyy). How can I add them together to get mm/yyyy into a new column?
I figured it out myself:
TO share:
=Date(yyyy,mm,dd)
If you have your number for month (5) in A1, number for year (2007) in B1, then this in C1
=DATEVALUE("1/"&A1&"/"&B1) result 01/05/2007 format to mm/yyyy
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks