Hey
So, I have to prepare monthly invoices. The date at the top is fine: I just have =today() in my inputs sheet. My problem is that I also have two other inputs: 'payment for November 2014' and 'payment due by the 1st of November 2014'.
I am trying to find a way to get excel to change the month, and year when necessary, automatically but to also keep my date formatting. Does anyone know how I do this? It is probably really simple. I started making an IF statement but it is too cumbersome.
Any help much appreciated!
Thanks
So, I have to prepare monthly invoices. The date at the top is fine: I just have =today() in my inputs sheet. My problem is that I also have two other inputs: 'payment for November 2014' and 'payment due by the 1st of November 2014'.
I am trying to find a way to get excel to change the month, and year when necessary, automatically but to also keep my date formatting. Does anyone know how I do this? It is probably really simple. I started making an IF statement but it is too cumbersome.
Any help much appreciated!
Thanks