Forum Discussion
Steven Tavener
Jul 11, 2018Copper Contributor
Adding column numbers together
Hi this is my first post, apologies i need help but I'm sure it simple for you. I have been tasked to create a list of items that we service at work so I've created a list on excel with the item descr...
Arul Tresoldi
Jul 11, 2018Iron Contributor
Check attachement if right; if it is, just hide the colored columns (select columns and click on "Hide columns", do not cancel them).
I just extracted day month and year from the last service date (yellow ones); then I told excel to add the month value for servicing (3, 6, 12 but you can also insert 1 or 38) in the orange column; I had also to add something to check if there's a year change (if you are in november aka 11 and you add 3, you won't arrive at month number 11+3=14 because it does not exist; you have to calculate by module12 so it's 14-12=2). If so, the brown column must change and add 1 year... at least! I had to add some other checks and formula to ensure that something that needs revision every 36 months (3 years) shows the right year in the "Next revision" column.
Steven Tavener
Jul 12, 2018Copper Contributor
Thanks, i will look into it