Converting University semester weeks into calendar dates

Options

Hello,

Can you help me convert University Semester Week Numbers into calendar dates? Can I use a conversion sheet to do this? For example, Spring Semester begins January 17, 2023- week 1. Can week one be converted to January 17, 2023? Thanks!!

Tags:

Answers

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    Are you able to provide a screenshot of your sheet for reference? It should be possible, but the structure and use could change the actual solution.

  • Toufong Vang
    Toufong Vang ✭✭✭✭✭
    edited 01/05/23
    Options

    @pkbarber26... If Week 1 is 01/17/2023, then Week 2 would be 7 days from 01/17/2023. Week 3 would be 14 days from 01/17/2023 and so forth.

    In other words, if your week number is "x" then finding the date for that week would be 01/17/2023 + (x-1)*7.

    Assuming that the academic week number is in a column labeled, "Academic Week", then your formula would be

    = DATE(2023,1,17) + (([Academic Week]@row - 1) * 7)

    If you want the formula to return the Mondays of the academic weeks, then use 01/16/2023 instead of 01/17/2023

    = DATE(2023,1,16) + (([Academic Week]@row - 1) * 7)



  • Genevieve P.
    Options

    Hi @pkbarber26

    I see you marked @Toufong Vang's response as not answering your question; did you receive an error or an incorrect result? If we've misunderstood the question, it would be helpful to see a screen capture, as Paul noted.

    Thanks!

    Join us at Smartsheet ENGAGE 2024 🎉
    October 8 - 10, Seattle, WA | Register now

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!