Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

startdate and enddate if week number is given

Status
Not open for further replies.
swetham

swetham

Programmer
May 5, 2010
257
DE
Hi,
Can anyone tell me the formula to find startdate and enddate if week number and year is given. I want the week numbers according to the ISO format ie, for 2010 week 1=jan 4 to 10. Week starts from Monday, week 53=dec27 2009 to jan 3 2010.


Thanks,
Sweish.
 
Sort by date Sort by votes
Please do not post the same thread multiple times.

-LB
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Bloke152
  • Locked
  • Question
Conditional number formatting in Excel export
Replies
3
Views
144
SkipVought
S
VHDN
  • Locked
  • Question
Reset page number
Replies
2
Views
176
VHDN
VHDN
PeteyN.O
  • Locked
  • Question
Crystal Report passing a date parameter to a number type field
Replies
3
Views
154
hilfy
hilfy
petejigsaw
  • Locked
  • Question
Suppress group if it contains both specified detail records
Replies
3
Views
162
lbass
lbass
Sherry B
  • Locked
  • Question
Crystal division by zero using if in
Replies
12
Views
296
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top