Converting University semester weeks into calendar dates
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!!
Answers

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.

@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 + (x1)*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)

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
Categories
Check out the Formula Handbook template!