lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
How to fill a column (let say 100 cells) with the same date? I typed A1=28/09/2018 and then auto fill but excel added 1 day to each cell. I tried to Right click auto fill --> series and then the End date 28/09/2018 but nothing get filled. The only way I see if i type in A1= today() and then auto fill A1. Is there any other way?
How to fill a column (let say 100 cells) with the same date? I typed A1=28/09/2018 and then auto fill but excel added 1 day to each cell. I tried to Right click auto fill --> series and then the End date 28/09/2018 but nothing get filled. The only way I see if i type in A1= today() and then auto fill A1. Is there any other way?
Last edited: