Home

Automatically fill rows with date groups?

AfonsoRod
New Contributor

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 have repeated date values, for example...

 

If we have dates like this, we just drag the fill handle and excel does the trick:

 

excel1.PNG

 

Now, if we have repeated dates like this, excel does this:

 

excel2.PNG

 

So, my question is, is it possible to make excel easily do this:

 

excel3.PNG

 

I'm sorry for the bad explanation, but basically I want to know if Excel can still automatically fill the date growth,  knowing that each date needs to be repeated once.

 

I thank you all in advance for the help.

Sincerely,

Afonso Rodrigues   

 

2 Replies

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)

 

excel4.PNG

 

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

 

 

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)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies