Date function

Solved/Closed
gayathrialagu
Posts
1
Registration date
Monday December 23, 2013
Status
Member
Last seen
December 23, 2013
- Dec 23, 2013 at 11:57 PM
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
- Dec 24, 2013 at 10:58 PM
i want to know how to create a date series in an excel.. for eg if i enter the date in A1 as 1.12.2013 how to create automatically in the A2 as 2.12.2013

1 reply

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
808
Dec 24, 2013 at 10:58 PM
in excel if you want to manipulate dates then you MUST ENTERE DATE as excel date either as m/d/yy orf d/m/yy according to regional configuration
either you can enter a formula in A2
=a1+1 (may be you have to format A2 as you like

on the other hand you can take the cursor to bottom right of A1 when cursor turns inot fill handle (+ sigal) and drage the mouse down.
1