a complex IF formula perhaps?
Hi all
I' trying to put a formula together which will calculate the % +/- of 2 cells dependent on today's date. Has anyone had any luck with this process before?
As you can see, I've already got O39 calculating difference between this current month and may last year and can manually amend the cells to June when the time comes. Is there a nested formula I can use to do this automatically? I got as far as trying multiple IFs but ended up going round in circles!
Any guidance welcome!
|