Kim_Ferar

4 - Data Explorer

since

‎Nov 29, 2022

User Statistics

1 Posts
0 Solutions
1 Kudos given
0 Kudos received

User Activity

Posts
Replies

Calculating school year using date field

Feb 06, 2022

Hi! I am looking for a formula to calculate the school year. I have a date field that I want to use. The formula I thought would work is not working. Please see below: IF(AND(Date>“08/15/2021”, Date<“06/30/2022”), “2021-22 School Year”, IF(AND(Date>“...

Kudos given to

User

Count