Hi, I am having a difficult time understanding date functions in excel.
I am trying to make this model a bit more dynamic. For New Bookings, I would like the bookings to repeat in what is called renewal bookings driven by the renewal period.
For example, in 1/1/18 I have 1000 new bookings. Since, in cell D18=12, I want it to renew every 12 months. However, it could be 24 or 36 months. Similarly, for
2/1/18, I have 1000 new bookings, and cell E18=12, I want it to renew every 12 months.
Is there an easier way to do this? I need a dynamic equation in lines 8 through 10. However if we could have a consolidated equation in line 8, that would be better. I greatly appreciate your help
I am trying to make this model a bit more dynamic. For New Bookings, I would like the bookings to repeat in what is called renewal bookings driven by the renewal period.
For example, in 1/1/18 I have 1000 new bookings. Since, in cell D18=12, I want it to renew every 12 months. However, it could be 24 or 36 months. Similarly, for
2/1/18, I have 1000 new bookings, and cell E18=12, I want it to renew every 12 months.
Is there an easier way to do this? I need a dynamic equation in lines 8 through 10. However if we could have a consolidated equation in line 8, that would be better. I greatly appreciate your help