I am working on a holiday booking form, the list has three main columns:

"Start Date","End Date" and "Year"

The purpose of the Year column is to show what holiday year the holiday has been booked in i.e. 2020/21, 2021/22 etc. The issue is that the holiday year runs from April to March so simply taking the year value from the Start or End Date columns doesn't work.


User books 20th December 2019 to 10th January 2020, this would be a booking in the 2019/20 holiday year.

Desired Result

I'd like a calculated column to be able to compare the dates in "Start Date" and "End Date" then output the holiday year i.e. 2020/21. The tricky bit, and where I am getting really stuck is that this calculation needs to work for future holiday years.

Any thoughts or pointers would be gratefully received.


1 Answer 1


Try below formula in the Calculated Column.

=CONCATENATE(YEAR([start date]))&"/"&CONCATENATE(YEAR([end date]))

enter image description here

  • Thanks for the reply Emily, in the end I used PowerApps to do the heavy lifting and that seems to be working well.
    – RobC_CTL
    Commented Apr 4, 2020 at 10:25
  • Congratulations on solving this issue. Commented Apr 24, 2020 at 1:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.