Autofill with specific condition

Pls, help.

 

How to populate Amout data in calendar fiel in right table from left with date on/off condition?

 

2016 2017
Amount date on date off 01.12.16 01.01.17 01.02.17 01.03.17 01.04.17 01.05.17 01.08.17
12345 01.01.17 01.05.17
?? ?? ?? ?? ??

By: Excell noob

Leave a Reply

Your email address will not be published. Required fields are marked *