This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question
jeculbNWRESD
Bronze 1
Bronze 1
Since ‎03-28-2024
a month ago

My Stats

  • 2 Posts
  • 0 Solutions
  • 1 Likes given
  • 0 Likes received

Casi_Ravi's Bio

Badges jeculbNWRESD Earned

View all badges

Recent Activity

Changing a Date to School Year

03-28-2024
In sheets, if I want to change a date to a school year (01/01/2024 is actually 2023-24), I write this formula=if(MONTH(date reference)>=7,YEAR(date reference) & "-" & RIGHT(YEAR(date reference)+1, 2),YEAR(date reference)-1 & "-" & RIGHT(YEAR(date ref...