Date function [Solved/Closed]

Report
Posts
1
Registration date
Monday December 23, 2013
Status
Member
Last seen
December 23, 2013
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
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

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
791
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
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month