create datevalue yyywwd

[jocke]

is there any way to create the datevalue yyyywwd (year, weeknr, day o
week) from today's date? in vba code or/and in a spreadsheet
tia

/jock

 

[Andy B]

Hi

Do you mean something like:
=TEXT(A1,"yyyy")&WEEKNUM(A1)&WEEKDAY(A1)
For today, that is 2004253
The WEEKNUM and WEEKDAY functions do have extra arguments which you should
check out, in case you need to use them

 

[Dave Peterson]

You may want to read Chip Pearson's notes on weeknumber:
http://www.cpearson.com/excel/weeknum.htm