UnderTheArmour
New Member
- Joined
- Dec 29, 2021
- Messages
- 8
- Platform
- Mobile
Hi all ? I'm trying to get Excel to calculate an expiry from a 4 digit WeekMnth number...
I want it to read the number as WeekYear, and calculate 9 years and 9 months from it to either create a warning, or change the colour of a number of cells or something...
It's for a sheet I use all the time, so if it just changes the colour of a line of key cells in a given row that would be enough... It's to calculate the 10 year expiry dates for tires that I have on multiple vehicles...
So for example when it hits 9 years, 6 months past the start date it could go yellow, orange at 9 years 9 months, and red when at the 9 years, 51 weeks point or something...
Sorry to all that I can't use the awesome mini-sheet feature as I'm doing all of this through handheld Android devices...
Thanks in advance, Mick ??
I want it to read the number as WeekYear, and calculate 9 years and 9 months from it to either create a warning, or change the colour of a number of cells or something...
It's for a sheet I use all the time, so if it just changes the colour of a line of key cells in a given row that would be enough... It's to calculate the 10 year expiry dates for tires that I have on multiple vehicles...
So for example when it hits 9 years, 6 months past the start date it could go yellow, orange at 9 years 9 months, and red when at the 9 years, 51 weeks point or something...
Sorry to all that I can't use the awesome mini-sheet feature as I'm doing all of this through handheld Android devices...
Thanks in advance, Mick ??