JansiJansi
New Member
- Joined
- Jun 22, 2022
- Messages
- 19
- Office Version
- 365
- Platform
- Windows
Hi all.
Here's the TL;DR of what I'm doing:
Taking a list of receive dates for items received in the past year, and putting that date in its corresponding bracket. Here's how it looks (ignore the data - it's not specific, just for example):
The way I'm finding the date of the age is by taking a receiving report, finding the most recent receive date for the SKU/item, and subtracting it from =TODAY(). I end up getting a number like 388 (after rounding) for 7/30/2021.
I need the table above to know that skux, for example, was last received 388 days ago, and insert the date 7/30/2021 into the "Age 366+" column in skux's row, etc.
Does anyone have a complicated formula that could accomplish this?
Thank you!
Here's the TL;DR of what I'm doing:
Taking a list of receive dates for items received in the past year, and putting that date in its corresponding bracket. Here's how it looks (ignore the data - it's not specific, just for example):
The way I'm finding the date of the age is by taking a receiving report, finding the most recent receive date for the SKU/item, and subtracting it from =TODAY(). I end up getting a number like 388 (after rounding) for 7/30/2021.
I need the table above to know that skux, for example, was last received 388 days ago, and insert the date 7/30/2021 into the "Age 366+" column in skux's row, etc.
Does anyone have a complicated formula that could accomplish this?
Thank you!