Dazzawm
Well-known Member
- Joined
- Jan 24, 2011
- Messages
- 3,748
- Office Version
- 365
- Platform
- Windows
I have a workbook that when I open it I would like the date in the column to be taken away from a year every time I open it and give result please.
So in example above row 1, 13/12/2021 there are 276 days until 13/12/2022. I would like the code to work this out and give the new answer when opened. So if I open file in 2 days time it will automatically say 274 Days and so on....thanks.
13/12/2021 00:00 | 276 Days |
23/09/2021 00:00 | 194 Days |
11/10/2021 00:00 | 213 Days |
20/09/2021 00:00 | 191 Days |
30/07/2021 00:00 | 140 Days |
So in example above row 1, 13/12/2021 there are 276 days until 13/12/2022. I would like the code to work this out and give the new answer when opened. So if I open file in 2 days time it will automatically say 274 Days and so on....thanks.