Forum Discussion
ID School Year in new cell based on full date field
I have a field with a course_start_date. I would like to create a new column for identifying school year based on a few month/year conditions. Can you help me write the correct formula? 1. If the mo...
Use
="SY "&YEAR(EDATE(A1,-6))&"-"&YEAR(EDATE(A1,-6))+1
If you have Microsoft 365 or Office 2021, you can also use
=LET(Yr,YEAR(EDATE(A1,-6)),"SY "&Yr&"-"&Yr+1)