Good morning.
I'm looking to calculate how many days an item has been active for on my spreadsheet.
I've messed around with formulas and a little bit of VBA, but can't get it to work.
There's a formula within row 1:1 that will highlight the cell green, and display the text "Today", based upon the dates in row 3.
This works fine, however I now need to know how long an item has been active for, from today's date, back until the letter "M".
Please see this image. It will explain it better!
https://imgur.com/a/K9uULIG
If anyone can help, I'd greatly appreciate it.
Many thanks.
I'm looking to calculate how many days an item has been active for on my spreadsheet.
I've messed around with formulas and a little bit of VBA, but can't get it to work.
There's a formula within row 1:1 that will highlight the cell green, and display the text "Today", based upon the dates in row 3.
This works fine, however I now need to know how long an item has been active for, from today's date, back until the letter "M".
Please see this image. It will explain it better!
https://imgur.com/a/K9uULIG
If anyone can help, I'd greatly appreciate it.
Many thanks.
