Hi Everyone,
Attached is the sheet I have to fill
1) "Start Date" will be next day after the "Current End Date" which i used "Start Date" + 1
2) "1 Year Price" or "2 Years Price" or "3 Years Price" will be "SLA1 Annual price" multiplied by 1,2,3 respectivley if "Last Date of Support" is NOT filled.
3) If "Last Date of Support" is there, then the "1 Year Price" or "2 Years Price" or "3 Years Price" end date depends on when "Last Date of Support" is. The end dates should not pass last date of support. If "Last Date of Support" is more than 3 years in time , then end dates to be for 1, 2, 3 years
Example: For "Product4", since "Last Date of Support" is 30-Sep-21, "1 Year End Date" for 1 year is "Start Date" + 1 year and the end date for "2 Years End Date" is "Start Date" + 2 years and End Date for "3 Years End Date" is till 30-Sep-21. for "Product6", though it has "Last Date of Support" but since it is more than 3 years, we calculate end dates for 1,2,3 years
4) "1 Year Price" , "2 Years Price" , "3 Years Price" uses the same concept but prorated to "Last Date of Support" . If "Last date of Support" more than 3 years, then we calculate for 1,2,3 years.
I am looking for generic formula that can do this
Let me know if this is confusion
Regards
RAjeev
Bookmarks