Help Please!

[Paulo Delgado]

Hello Everyone!

New here!

I would need some help from someone who could help me.

I developing one excel file and i need to fill some cells with some automatic information based on 2 other cells:
A B C D E F G H
1 Nº Nights 7
2 Check In 08/11/2017

I Want to fill the collums D2, E2, F2, G2, H2, ... with base on the number o nights present in collums C1. If i put 7 nights on the C1 the formula will fill the D2 with C2+1 etc...until 7 nights, but have to stop at 7 nights. If i put 14 nights the D2 and next ones will be fill with C2+1 until 14 nights.

I hope that i was clear.

Waiting for your help please.

Best regards
Paulo Delgado

 

[NARAYANK991]

Hi ,

In D2 enter :

=IF(COUNT($C2:C2) < $C$1, MAX($C2:C2)+1, "")

Copy to the right as far as you want.

Narayan

 

[Paulo Delgado]

Hello NARAYANK991,

Thank you very much!

It worked perfectly!

Thank you for everything.

Best Regards
Paulo Delgado