hello, I work in a college and my boss is trying to create a formula that takes the graduation date and subtracts the admit date to get the number of terms it took to complete a degree. this sounded easy however the dates are not in typical excel format. The registrars office uses the year followed by term. fall term=01, Winter=02, Spring=03, Summer = 04.
EX: 201801 (fall term 2018)
im not sure if it is possible but my boss wants to create a formula that will take EX: grad date 200304 - Admit date 200204 = #terms (4/year) (in this case it would =4)
Solved by O. B. in 20 mins