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 1863 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
Related:

1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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