Hello All,
I am trying to utilize the Mod function. I want to trigger a formula every x months (in this example I just used a value of $10 instead of a formula and chose every 3 months). The mod function works great in doing that, but my only question is, is there any way to get it to start at column C as opposed to column A? It counts every N months from column A, so three columns over from column A is column D which shows Jan-22. I ideally would like it to count every N months from the starting point of column C, not column A. So three months from Column C would put it at Column F which is Mar-22. I know I could just move everything over so my first month is in column A but unfortunately that is not an option for me.
Thanks to any and all attempts to help!
I am trying to utilize the Mod function. I want to trigger a formula every x months (in this example I just used a value of $10 instead of a formula and chose every 3 months). The mod function works great in doing that, but my only question is, is there any way to get it to start at column C as opposed to column A? It counts every N months from column A, so three columns over from column A is column D which shows Jan-22. I ideally would like it to count every N months from the starting point of column C, not column A. So three months from Column C would put it at Column F which is Mar-22. I know I could just move everything over so my first month is in column A but unfortunately that is not an option for me.
Thanks to any and all attempts to help!