Hi,
How do automatic date populate row wise against date. Starting date is date 20/03/2017 in row A1. I would like learn for formulas.
REQUIRED FORMAT
20/03/2017
21/03/2017
22/03/2017
23/03/2017
24/03/2017
25/03/2017
26/03/2017
27/03/2017
28/03/2017
29/03/2017
30/03/2017
31/03/2017
01/04/2017
02/04/2017
Hi Silam
By dragging the date downward or across we get the next dates automatically. What way you want to update'em?
Teach me Excel VBA
Thank for your reply ImranBhatti. I know the way drag down and fill series but I want know the formulas.
Try this in A2 and drag down.
=DATE(YEAR(A1),MONTH(A1),DAY(A1)+1)
Or:
=A1+1
thank you so much for your help.
Welcome silam
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks