Hi there.
So I have the next 2 columns:
........... H............ |........... I
Total num. of days | The dates used - num. of days used
............ 13 ........ | ..... 02.01.2024-05.01.2024-4,
...................................09.01.2024-12.01.2024-4,
...................................07.05.2024-10.05.2024-3,
...................................05.08.2024-06.08.2024-2
I need a formula that sums the numbers after the "-", so 4+4+3+2, and then subtracts from the total number of days, so 13-13=0.
I'm looking forward to your responses.
Bookmarks