Date

G

Ginny

So simple, yet I can not seem to get this right. I need month/year only in
one cell.
Thanks.
 
I

IC

If you mean to only display month/year of a full date, then custom format
the cell to mm/yyyy to display 01/2005.

If you mean you need to extract and display only the month/year from a full
dat ein another cell then use =MONTH(A1)&"/"&YEAR(A1) for give 1/2005.

Ian
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge skipping records/sending one at a time 0
Send meeting request for different dates (no repetition) to different people 0
Expanding Date Formula 0
Continues to move to the right 0
Automation of scanned file storage based on content 0
Incone & Expenses Statement 0
SUMIF between date range 0
Space at end of multi page list to accommodate new entries 1

Top