| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
populate month-yyyy when compare 2 cells
Dear Forum,
I have a scenario where I need to compare 2 date cells. When cell1 empty then take cell2 and format the date month-yyyy in cell3. When cell1 not empty then take cell1 date and format the date month-yyyy in cell3. i need advise how can i do that and create macro to automate the change. example c d e 20100220 feb-2010 c d e 20100521 20100220 may-2010 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells from mm/dd/yyyy to yyyy | New Users to Excel | |||
| Excel function to convert month-day-year to mm/dd/yyyy | Excel Worksheet Functions | |||
| How to show only Month of a mm/dd/yyyy format? | Excel Discussion (Misc queries) | |||
| Converting Day, Date Month Year format to MM/DD/YYYY | Excel Worksheet Functions | |||
| I can't convert from mm/dd/yy to month dd, yyyy | Excel Discussion (Misc queries) | |||
Threaded Mode
