How to Update a date in a cell automatically in series column

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

How to Update a date in a cell automatically in series column

Post by siamandm »

Hello All,

If i have a table in excel with a column Date, how to make the other cells below the first one automatically updated when the first cell which contain date is update, the column consist of a a series of date in other word, when the frist cell dates changed the other celles below it in crease in days

days.png
You do not have the required permissions to view the files attached to this post.

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

Re: How to Update a date in a cell automatically in series column

Post by siamandm »

currently im using =A1+1 in the A2 cell which i think is not professional

User avatar
StuartR
Administrator
Posts: 12577
Joined: 16 Jan 2010, 15:49
Location: London, Europe

Re: How to Update a date in a cell automatically in series column

Post by StuartR »

siamandm wrote:
24 Oct 2022, 07:16
currently im using =A1+1 in the A2 cell which i think is not professional
That's exactly what I would do
StuartR


User avatar
HansV
Administrator
Posts: 78236
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: How to Update a date in a cell automatically in series column

Post by HansV »

That's the way I would do it too... (I assume you meant =A2+1 in A3)
Best wishes,
Hans

siamandm
5StarLounger
Posts: 1192
Joined: 01 May 2016, 09:58

Re: How to Update a date in a cell automatically in series column

Post by siamandm »

thank you very much for the confirmations
Regards