| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Date Format
Using Excel 2003. (Australian Date Format).
In Cell B3, I want to type the month and year, eg: April 2008. In Cell E33, I want to put =B3 so that the result appears as the last day of the month, eg: 30/04/2008. In Cell B3, I put a Custom Date Format of mmmm yyyy. How do I get E33 to return me the last day of the month entered? Lindy |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Looking for custom date format | Excel Worksheet Functions | |||
| Custom Date & Time format | Excel Worksheet Functions | |||
| Date Format in Custom Header | Excel Discussion (Misc queries) | |||
| Custom format date | New Users to Excel | |||
| Custom Date format ie. 01.01.05 W1 (W1 is week 1) | Excel Discussion (Misc queries) | |||
Threaded Mode
