I want to do it for a self updating datestamp on a gift voucher so that when it's printed it requires very little interaction from the staff in order to print with all fields filled in correctly.
I think I can do it using excel by:
=today() in A1
=date(year(a1),month(a1+6),day(a1))
However, for some reason this is not working, I can add days onto todays date but the month and year won't change.
Why would I bother making something like this up, that would be extremely petty and a complete waste of time.
Edit: I'll just break it down into it's component parts and put it back together. It should work then.
Another Edit: It would seem I cannot specify the year or month using =date, no matter what I type the date returned is day/01/1905. I can only change the day for some reason.