Converting University semester weeks into calendar dates

pkbarber26

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!!

Paul Newcome

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.

TVang

@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.

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!