create datevalue yyywwd

J

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
 
A

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
 
Top