Forum Discussion

AfonsoRod's avatar
AfonsoRod
Copper Contributor
Jan 16, 2019

Automatically fill rows with date groups?

Hi everyone   So, I know that in Excel we can easily fill rows with dates just by dragging the fill handle and Excel does that automatically. My question is if we can do that automatic fill if we h...
excel
AfonsoRod's avatar
AfonsoRod
Copper Contributor
Jan 16, 2019

So, I kept trying to understand if and how this can be done, and I've already figured it out. So, imagine you have the spreadsheet above and you want to repeat each date 3 times (for example)

 

 

You just need to place your cursor in C6 and write this formula: =if(C5=C3;C5+1;C5).

Basically the formula is saying that, if the cell C5 its the same as the cell C3, excel nedd to add one more day, otherwise excel just writes the same date.

 

Hope this can be helpful to anyone :) 

 

 

  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Jan 16, 2019

    There is another trick exists

    - put in C3 Jan 01 and in C6 Jan 02. Keep all other cells (C4, C5, C7, C8) blank

    - select C3:C8, drag selection down by right mouse till end of your desired range, Fill Series (or Fill Days)

    - F5, Special, select Blanks, Ok

    - keeping selection in formula bar type =C3 and Ctrl+Enter

    Dates are filled now.

     

    By the way, another way to write your formula is

    =C5+(C5=C3)

Resources