ExcellinglyStupid
New Member
- Joined
- May 12, 2022
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello, hoping someone can help my immensely dense brain. The end goal here is that I want the value (amount of days) in a cell to change, depending on whether another cell has a date in it or not. Make sense? Hopefully it will…
I'm working with dates and business days; so I have a column for date when something was received (D2), and in another cell J2 I'm keeping track of the amount of working days since D2 date. I figured this formula out, but here's the tricky bit. I want that number to stop counting when a date is entered into ANOTHER cell, at I2. So I want the value cell (J2) to show amount of working days between the dates in D2 and I2, but I also want the days to keep on tracking if there is no date in I2.
In the screenshot below you can see the columns I'm referring to, and the existing formula there in J2 calculating working days so far. If any more resource is required, please explain in layman's terms and I'll do my best, any help would be greatly appreciated.
Thanks
I'm working with dates and business days; so I have a column for date when something was received (D2), and in another cell J2 I'm keeping track of the amount of working days since D2 date. I figured this formula out, but here's the tricky bit. I want that number to stop counting when a date is entered into ANOTHER cell, at I2. So I want the value cell (J2) to show amount of working days between the dates in D2 and I2, but I also want the days to keep on tracking if there is no date in I2.
In the screenshot below you can see the columns I'm referring to, and the existing formula there in J2 calculating working days so far. If any more resource is required, please explain in layman's terms and I'll do my best, any help would be greatly appreciated.
Thanks