I’m pretty sure this isn’t possible, but I just want to make sure I’m not missing something. I have a column that contains only a year. More specifically, the year that a student graduates from high school. Does anybody know if it’s possible to do some date math where I can subtract today’s date from 05/31/year, where the year is dynamic based on another column? Basically, I’ll always have a date of May 31st, but the year will depend on the graduation year. I’m currently doing it in a google sheet, but I’d love to accomplish this in a glide math column. I’m trying to figure out how to dynamically build a date by joining the year to 05/31 and have it be recognized as a date so I can perform date math on it.
I’m sure I can dig up some sort of complicated math formula to do it, or some action that would write a template of the date to a date column, so I’m not looking for too much effort on anybody’s part. I’m just wondering if there is a simple way to use text based dates with date math.