formula for day date in a year

[VbaHell]

Hello all

Is there a formula please that if I enter a date

IE: 01/03/2019 (Ist Mar 19)

That I can drag down which will add all the other correct dates each day

 

[RoryA]

Assuming you enter the date in A1, you can simply enter:

=A1+1

in A2 and then copy down as far as you need to.

 

[VbaHell]

Just found this

=DATE(YEAR(A3),MONTH(A3), DAY(A3)+1)

 

[VbaHell]

Rory A will this take into account the correct number of days in each month please

 

[RoryA]

Yes it will.

 

[tyija1995]

Hi VbaHell,

Yep RoryA's formula will work because dates are actually just serial numbers in Excel! the number 1 is the date 01/01/1900, so 2 = 02/01/1900 and so forth. Always good to know!

 

[VbaHell]

Thanks Guys