Hi Guys,
Hoping someone could help i need to create a formula for a date range.
2) In the navy blue area to the right (starting in cell M11), create a formula where each calender year is individually numbered.
* i.e; all of the first year will be Year 1, the following year is Year 2 etc.
Essenttiyy there are 5 years worth or data. So i need a formula that would say above the date e.g 01/02/19 would be YEAR 1, 01/03/20 Would be year 2 and so on.
thanks for helping
Excel.PNG
Bookmarks