ExcelBanter - Custom Date format ie. 01.01.05 W1 (W1 is week 1)

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Custom Date format ie. 01.01.05 W1 (W1 is week 1) (https://www.excelbanter.com/excel-discussion-misc-queries/2641-custom-date-format-ie-01-01-05-w1-w1-week-1-a.html)

aspen

Custom Date format ie. 01.01.05 W1 (W1 is week 1)

aspen

Sorry I meant to ask how do I make a Custom Format for this

Frank Kabel

Hi
there's no custom format for this available

--
Regards
Frank Kabel
Frankfurt, Germany
"aspen" <HelpPlease schrieb im Newsbeitrag
...

Fred Smith

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

All times are GMT +1. The time now is 02:23 PM.