Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jun 22, 2021 07:06 PM
I would like to create a formulas to add the specific school year if the date in the column “DATE” is between DATE1 and DATE2
For example:
Solved! Go to Solution.
Jun 22, 2021 07:55 PM
You can probably use the WEEKNUM formula. The following formula should work.
IF(WEEKNUM(Date)>20,CONCATENATE(YEAR(Date),"-",YEAR(Date)+1),CONCATENATE(YEAR(Date)-1,"-",YEAR(Date)))
Where 20 is the week after which want to count it towards the next school year. It could be any week you want. Also within a week, it can be anyday (like Sunday or Monday). I ommited the day, so by default it’s assumed Sunday is the first day of the week.
Jun 22, 2021 07:55 PM
You can probably use the WEEKNUM formula. The following formula should work.
IF(WEEKNUM(Date)>20,CONCATENATE(YEAR(Date),"-",YEAR(Date)+1),CONCATENATE(YEAR(Date)-1,"-",YEAR(Date)))
Where 20 is the week after which want to count it towards the next school year. It could be any week you want. Also within a week, it can be anyday (like Sunday or Monday). I ommited the day, so by default it’s assumed Sunday is the first day of the week.
Jun 23, 2021 05:42 AM
Brillant ! It works perfectly, thanks !
Jun 23, 2021 03:59 PM
Great. Please take a minute to mark the reply as the solution. Much appreciated!