Adding Month and Year formulas

ejgallagher

Board Regular
Joined
Aug 3, 2002
Messages
123
I would like to add the month formula and the year formula in a cell. I have been tryin =(Month(w2)),(Year,(w2)) to no avail. Any ideas?

Thanks in advance,

Ed Gallagher
 

Some videos you may like

Excel Facts

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

ejgallagher

Board Regular
Joined
Aug 3, 2002
Messages
123
GReat - how do i set this up as a date. How do i insert a slash or whatever!

Thanks
 

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
Don't you already have a date in W2, which you could reference directly and format as mm/yyyy?

You can add a slash like this:

=MONTH(W2)&"/"&YEAR(W2)

but it will be a text entry not a true date.
 

Watch MrExcel Video

Forum statistics

Threads
1,119,127
Messages
5,576,235
Members
412,709
Latest member
AD04
Top