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
How to Update a date in a cell automatically in series column
-
- 5StarLounger
- Posts: 1192
- Joined: 01 May 2016, 09:58
How to Update a date in a cell automatically in series column
You do not have the required permissions to view the files attached to this post.
-
- 5StarLounger
- Posts: 1192
- Joined: 01 May 2016, 09:58
Re: How to Update a date in a cell automatically in series column
currently im using =A1+1 in the A2 cell which i think is not professional
-
- 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
That's exactly what I would do
StuartR
-
- 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
That's the way I would do it too... (I assume you meant =A2+1 in A3)
Best wishes,
Hans
Hans
-
- 5StarLounger
- Posts: 1192
- Joined: 01 May 2016, 09:58
Re: How to Update a date in a cell automatically in series column
thank you very much for the confirmations
Regards
Regards