Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi All,

    I am planning to build a weekly report to track capacity utlisation.

    While im able to get the week number and generate by report. I was wonder is there a way to get the start and end date of the week so people view the report know the week they are looking at.

    For eg. Week 50 - 6-Dec - 10 Dec

    Regards
    Baiju

  2. #2
    Silver Lounger
    Join Date
    Jul 2001
    Location
    Ottawa, Ontario, Canada
    Posts
    1,609
    Thanks
    0
    Thanked 1 Time in 1 Post
    Quote Originally Posted by Baiju G Nath View Post
    For eg. Week 50 - 6-Dec - 10 Dec
    Hello Baiju

    The attached workbook shows 3 approaches to solving your problem.

    H.T.H.

    [attachment=90853:FY_in_Weeks.xls]
    Attached Files Attached Files
    Regards
    Don

  3. #3
    2 Star Lounger
    Join Date
    Jul 2006
    Location
    Bangalore, India
    Posts
    180
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks Don, this is exactly what i was looking for, since im a formula person i would use the solution 1 for the same.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •