So I'm running into a snag and need some help.
I'm trying to write a dynamic formula that gives me the number of days in my contract every quarter. I'm trying to formulate my support documentation to match IT logic.
My known, I have a start date, end data, and current quarter/year that i'm in.
I can figure out the first quarter, mid term, and last quarter by the contract dates but manually input the end date of the first quarter or beginning date of the last quarter. Can that be done automatically?
I need to manually spread the mid term amount for each quarter in between but need to ignore that spread for the first and last quarter. The mid term spread will be a decimal between 90-92 days depending on the quarter.
The formula I'm looking for:
Row 2, I would take my contract value/29 days (first quarter of deal)
Row 3, I would take my contract value/91.45 days (mid term)
Row 4, I would take my contract value/89 days (last quarter of deal)
I know this is a unique ask but it's what I'm working with. I appreciate any help I can get. Thanks in advance.
I'm trying to write a dynamic formula that gives me the number of days in my contract every quarter. I'm trying to formulate my support documentation to match IT logic.
My known, I have a start date, end data, and current quarter/year that i'm in.
I can figure out the first quarter, mid term, and last quarter by the contract dates but manually input the end date of the first quarter or beginning date of the last quarter. Can that be done automatically?
I need to manually spread the mid term amount for each quarter in between but need to ignore that spread for the first and last quarter. The mid term spread will be a decimal between 90-92 days depending on the quarter.
The formula I'm looking for:
Row 2, I would take my contract value/29 days (first quarter of deal)
Row 3, I would take my contract value/91.45 days (mid term)
Row 4, I would take my contract value/89 days (last quarter of deal)
I know this is a unique ask but it's what I'm working with. I appreciate any help I can get. Thanks in advance.