Adding numbers to output dates

MasterMonk · #1 05-03-2007, 04:51 PM

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?

MasterMonk · #2 05-03-2007, 04:53 PM

I figured it out myself:

TO share:

=Date(yyyy,mm,dd)

**oldchippy** · #3 05-03-2007, 04:59 PM

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

Welcome to the Excel Forum

Forum Statistics