I can get the date inserted that the document was last saved, but can I get it to insert day saved + 1 year?

Living the dream today…

😉

These little things that seem like they should be so easy never fail to be mind-blowingly difficult

http://www.gmayor.com/insert_a_date_other_than_today.htm

Save it tomorrow.

HTH 😉

Mmmm, looks like typing it is easier…

=date(year(today())+1,month(today()),days(today()))

Does that work?

If you don’t want to use that macro can you insert the date formatted as only the day and month then type the year? Just leaves the year to be manually changed once a year.

And to change the subject, was it you who was left stranded by Autoaid and did you sort them out?

Yes it was. I sent them in my letter and policy info afterwards. Partly my fault (old address AND car details 😳 ) but they were given them on phone in case. Mucho grovelling and very apologetic letter and this year is free….

If today’s date is =Today() (that’s for a dynamic date, tomorrow your spreadsheet will include tomorrow’s date)

The same date next year is =Today+365 (or 366 if it’s a leap year)

excel puts dates in some kind of numerical format so you can just add days on to it.

MS Word

spreadsheet

What we have here is failure to communicate

You can nest field codes to add 1 to the year.
Press Ctrl+F9
Put:
DATE \@ “yyyy”
between the curly brackets.
select the whole thing (including the brackets) and press Ctrl F9 again.
Put = after the first bracket and +1 before the last.
You should have
{={DATE \@ “yyyy” } +1}
or possibly {= 2015 +1 }

Don’t add curly brackets let the Ctrl+F9 do this.

http://www.addbalance.com/word/datefields2.htm

this year is free….

Good to hear you got it sorted as I have a policy with them. Hopefully yours was a rare occurrence.

I always struggled with dates in Word.

I always struggled with words on dates.

I’ve always struggled with stones in dates.

I’ve always struggled with dates when stoned.

(Note to anyone at work reading this: This Is A Joke.)