Need help with Copy and Paste

[SWilmore]

Hello!

I'm new to the forum and have been self teaching Excel over the last few months. I have some great resources at work, but I feel like being part of an Excel community may be even more beneficial.

I'm wondering how I can achieve the following and excuse my description as I am a super beginner as this!

I have cells that have full dates/times (4/17/2013 2:50:58 PM) and I have converted the cells to read what's desired (April 2013). Now I'm trying to do a VLOOKUP formula and it's using the date and time data instead of the month and year data. How can I switch the "behind the scenes" data from the full dates and times to reflect what's desired (month and year)?

Let me know if I can clarify anything!
Thanks!

[Tony Valko]

The INT function will return just the date:

A1 = 4/17/2013 2:50:58 PM

=INT(A1)

Formatted as Date = 4/17/2013

If you have a column with many dates/times then show us the complete VLOOKUP formula you're wanting to use.