Help in Excel formulas (maintenance schedule)!!

[hayekj]

Hello, I wou

l'd be very grateful to the one who would be able to help me with this :

I am trying to calculate the next due date based on today’s date and maintenance frequency (days, months and year)….

Would you be able to add your magical formula for the ‘maintenance period’ and ‘days to maintenance’ ? (the green and red cells)

Thanks!!
PS - the photo is attached below.

-- corrupted image removed --

 

[Special-K99]

You cant attach files on this forum

 

[hayekj]

You cant attach files on this forum

How can I attach the file? Thanks!

 

[Special-K99]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

 

[hayekj]

You cant attach files on this forum. There are tools on this forum for adding small spreadsheet images

https://www.mrexcel.com/forum/about-board/508133-attachments.html

Or upload the file to an online storage site and post a link to it, though some people may not download the file for fear of viruses.

I wonder if you could now see what I mean - I am looking to get the formula for 'Maintenance period date' and 'days to maintenance' :

Category	Name	Start	Expiration	Days	Month	Year	Maintenance period date	Days To Maintenance
Residence maintenance contract	Apple Electronics	01-11-2018	31-12-2018	x	y	z

<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[Special-K99]

Need a full explanation of how to calculate those two figures.