smide
Board Regular
- Joined
- Dec 20, 2015
- Messages
- 162
- Office Version
- 2016
- Platform
- Windows
Hello.
In cell A1 I have current date created with formula =today() eg. 3-Oct-2019.
In the same column starting from cell A3 (A3:A600) I have dates and time in format dd.mm.yyyy - hh:mm (example. 04.10.2019 - 21:00).
All those cells (A3:A600) are text cells. I need to subtract all those dates (A3:A600) and current date. Result(s) should be the difference expressed in days (column B).
example.
<tbody>
</tbody>
In cell A1 I have current date created with formula =today() eg. 3-Oct-2019.
In the same column starting from cell A3 (A3:A600) I have dates and time in format dd.mm.yyyy - hh:mm (example. 04.10.2019 - 21:00).
All those cells (A3:A600) are text cells. I need to subtract all those dates (A3:A600) and current date. Result(s) should be the difference expressed in days (column B).
example.
A | B | |
1 | 3-Oct-2019 | |
2 | ||
3 | 30.09.2019 - 17:30 | -3 |
4 | 01.10.2019 - 22:00 | -2 |
5 | 02.10.2019 - 16:00 | -1 |
6 | 02.10.2019 - 21:00 | -1 |
7 | 03.10.2019 - 12:00 | 0 |
8 | 04.10.2019 - 16:45 | 1 |
9 | 05.10.2019 - 13:00 | 2 |
<tbody>
</tbody>
Last edited: