Cant put consecutive dates on excel

Question

I am trying to put consecutive dates in excel

I manually type in 3 consecutive date dates

When i use the drag handle to continue the consecutive date it is just repeating the dates.

How do I fix this please

Answer 1

it has a list of options. The only one not greyed out is copy text

Answer 2

Where and how do i put =SEQUENCE(30,,today0,1)

Answer 3

it has a list of options. The only one not greyed out is copy text

Answer 4

I suspect your dates aren't recognized as such. When you enter a real date value in a cell you can just pull it down or across and Excel will automatically increment the dates for you. Can you show exactly what you entered in the three cells you mentioned?

Since you seem to have MS365, you could, for example, also try this:

=SEQUENCE(30,,TODAY(),1)

This will spill a sequence of 30 date values as from today. Format as Date afterwards.

Answer 5

Hello ChrisWilson1963,

Thank you for coming to the forum and I will be happy to assist in the best way I can.

When you drag it down you will see a small square at the side, click it and select fill series

see the image below:

Let me know how it goes

Kind Regards Fuad