Adding Month and Year formulas

[ejgallagher]

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

 

[Andrew Poulsom]

You mean?

=MONTH(W2)&YEAR(W2)

 

[ejgallagher]

GReat - how do i set this up as a date. How do i insert a slash or whatever!

Thanks

 

[Andrew Poulsom]

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.

 

[rwcjr]

=DATE(YEAR(W2),MONTH(W2)+1,DAY(W2))