what formula I do write for the following
I have several different dates and if it fall between a certain date I want it to display contract 1 number in the Contract Column if it between another date I want it to display contract 2 in the Contract Column. Below is just a mock
Contract 1 number is anything dates between 06/01/2019-05/31/2023 & Contract 2 is any dates between 06/01/23-05/31/25