CODEWITHSUNDEEP
excelexcel-formula
Evgeniy Kleban
Evgeniy Kleban

Reputation: 6940

Create a column with calendar date in Excel

I have a sheet in Excel, what I want is, to create a column, where each row starts with a specific date, for example, "3 april 2017". Then, when I drag and scroll bottom I want it to increase by one day.

So, basically, I want to create a sheet where each row starts with a specific date, where the first date is equal to now date, and next row is today date + 1 day.

I'm not very keen in Excel and I tried =WEEKDAY and =DAYformulas, but I could not get what I want.

Is there any formula I can use to easily achieve this task?

Upvotes: 0

Views: 938

Answers (1)

CallumDA
CallumDA

Reputation: 12113

As discussed in the comments, Excel stores dates as numbers so to add a day to a date you simply need to add one to it:

=A1+1

... for example, when the original date is in cell A1.

To format this as you require, use the following custom format string:

d mmmm yyyy

Upvotes: 4

Related Questions