Auto-fill the same date multiple times

[RULIANA]

At work we keep worksheets that contain the information for scheduled hours run on a machine and I was looking for a way to automatically populate the date row without the need to copy and paste the same day over and over for the list of machines for each day.

Ex. Machine           Date

      101                  6/1/2019

      102                  6/1/2019  

      103                  6/1/2019

      104                  6/1/2019

      105                  6/1/2019

      101                  6/2/2019

      102                  6/2/2019

      103                  6/2/2019

      104                  6/2/2019

      105                  6/2/2019

etc...

[#2 · Accepted solution]

@RULIANA 

It depends. If, for example and as variant, your list of machines is always in the same order, you may use the name of the machine first in list as the trigger to move on another day. For this

in B3 it could be

=B2+(A3=101)

and drag it down till end of the range. Assuming you don't skip weekends and public holidays.

[#3]

@Sergei Baklan 

Hi Sergei,

Thanks for the reply but will this work if the machine list is stored as text and not a number?

[#4]

@RULIANA 

Actually the same:

and

=B2+(A3="M101")