Forum Discussion

Steven Tavener's avatar
Steven Tavener
Copper Contributor
Jul 11, 2018

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 description, asset number etc and also a 'frequency' column with how often the item needs servicing 3, 6 or 12 (months) and 'last serviced' date. What i need help doing is adding the frequency number to the date in the next column. For example the last serviced date is 12/04/18 and the frequency is 3 is there a way to add them together to make 12/07/18 (UK) ? If anyone knows what i mean and can help that would be great, thank you.
Formulas and Functions
  • Arul Tresoldi's avatar
    Arul Tresoldi
    Iron Contributor
    Jul 11, 2018

    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.

Resources