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' :

[TABLE="width: 1004"]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Category[/TD]
[TD]Name[/TD]
[TD]Start[/TD]
[TD]Expiration[/TD]
[TD]Days[/TD]
[TD]Month[/TD]
[TD]Year[/TD]
[TD]Maintenance period date [/TD]
[TD]Days To Maintenance[/TD]
[/TR]
[TR]
[TD]Residence maintenance contract[/TD]
[TD]Apple Electronics[/TD]
[TD]01-11-2018[/TD]
[TD]31-12-2018[/TD]
[TD]x[/TD]
[TD]y[/TD]
[TD]z[/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

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