|
|
#1
09-30-2016, 08:29 AM
|
|||
|
|||
Problem with Dates
Dear A B C D Date Month Year Arr_date 13 5 2016 =date(c2,b2,a2) - it shown 2016-5-13 However, i would like to show as "May-13 " ( i need to show the month and year, as i then take this for Pivot Table , so i need that just MMM-YY How can i do that ? Eric 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Autofill dates - how can I get the same date and consecutive dates? | Exhale | Excel | 3 | 04-05-2016 03:11 AM |
 IF formula using dates
|
rindelsk | Excel | 1 | 04-06-2015 01:15 AM |
|
Changing Actual Finish dates changes original Finish dates
|
SomewhereinTX | Project | 3 | 12-20-2013 10:25 AM |
|
Calculating dates
|
Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |
| Adding dates | mkkram | Word | 0 | 11-27-2006 09:18 AM |
Windows 7 32bit 
Office 2000
Threaded Mode