Technical Notes
Friday, January 27, 2017
Excel convert YYYYWW to date
=
DATE
(
LEFT
(
A1
,
4
)
,
1
,
-
2
)
-
WEEKDAY
(
DATE
(
LEFT
(
A1
,
4
)
,
1
,
3
)
)
+
RIGHT
(
A1
,
2
)
*
7
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment