tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Please help i'm getting a bit confused here.
What it is is i have two coloumns "In date" and "Out Date"
In date is column G
Out Date is Column J
So we charge whilst an item is "In stock" per day.
What I want to be able to do is instert a start date and end date and caculate how many days each row was in stock durring that period in days.
so for example:
Please help i'm getting a bit confused here.
What it is is i have two coloumns "In date" and "Out Date"
In date is column G
Out Date is Column J
So we charge whilst an item is "In stock" per day.
What I want to be able to do is instert a start date and end date and caculate how many days each row was in stock durring that period in days.
so for example:
Days in stock between | |||||||||
Q7 | S7 | ||||||||
Column G | Column J | Column M | 01/06/2021 | 15/06/2021 | |||||
In Date | Out Date | Days in stock | |||||||
1/1/2020 | 27/7/2021 | 15 | |||||||
14/06/2021 | 1 | The red are the numbers i'm try to caculate | |||||||
01/05/2021 | 03/06/2021 | 3 | |||||||
1/04/2020 | 15/07/2020 | 0 | |||||||