| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Custom Date format ie. 01.01.05 W1 (W1 is week 1)
|
|
#2
|
|||
|
|||
|
Sorry I meant to ask how do I make a Custom Format for this
|
|
#3
|
|||
|
|||
|
Hi
there's no custom format for this available -- Regards Frank Kabel Frankfurt, Germany "aspen" <HelpPlease schrieb im Newsbeitrag ... |
|
#4
|
|||
|
|||
|
You could create a formula to display the date in format you want, eg:
=TEXT(TODAY(),"mm/dd/yy")&" W"&TEXT(WEEKNUM(TODAY()),"@") -- Regards, Fred Please reply to newsgroup, not e-mail "aspen" <HelpPlease wrote in message ... Sorry I meant to ask how do I make a Custom Format for this |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Format date dd.mm.yyyy to dd/mm/yyyy | Excel Discussion (Misc queries) | |||
| USING THE DATE FORMAT IN EXCEL | Excel Discussion (Misc queries) | |||
| Date format collapses diagram | Excel Discussion (Misc queries) | |||
| Problem with Date format from VBA code | Excel Discussion (Misc queries) | |||
| Date on two lines using a custom cell format possible? | Excel Discussion (Misc queries) | |||
Linear Mode
