Wondered if someone could help me as I racking my brain on these 2 queries which I'm sure are quite simple but I'm having trouble nonetheless.
I have created a spreadsheet for managing support renewals in a single summary document for ease of administration, I have 2 requirements which I need assistance with:
1. Currently if the "end date" of support is within "today's date" it will be display "current" however if false it will be classed as "expired". How do I create a formulae that extends the above if the end date is within 60 days of today's date it states "renew"?
Formulae - =IF((TODAY()-H9)>0, "Expired", "Current")
I believe I need to use AND but not sure quite how?
2. On the second tab of the attached test spreadsheet I have created I would like it to take data from the first tab based on when the support expires and breaks this down by year. From here I plan on calculating the support renewal cost on a yearly basis.
All help if greatly received.
Thank you in advance
Bookmarks