Our corporate year end is 31-MAR each year. 31-MAR-18, 31-MAR-19 and so on. Not a fixed number as time doesn't stop.
If I have the date 01-OCT-18 in cell A1, I want to put into cell A2 the number of months until the NEXT year end, 31-MAR-19. Or even the fraction of the year remaining. Either...