Year +1 or Year +2
cyber_jeunefemmeendétresse
-
Raymond PENTIER Posted messages 58226 Registration date Status Contributor Last intervention -
Raymond PENTIER Posted messages 58226 Registration date Status Contributor Last intervention -
Hello,
As part of my work, I would like to automatically insert the current date into a Word document, but only the year, to which I would like to add one or two years.
Specifically, I want a formula that will automatically display 2008 (=year + 1) and 2009 (=year + 2) for a document created in 2007.
I took a look in "Insert/Field" but couldn't find a solution...
Could someone help me?
Thank you in advance
Cyber_youngwomanindistress!
As part of my work, I would like to automatically insert the current date into a Word document, but only the year, to which I would like to add one or two years.
Specifically, I want a formula that will automatically display 2008 (=year + 1) and 2009 (=year + 2) for a document created in 2007.
I took a look in "Insert/Field" but couldn't find a solution...
Could someone help me?
Thank you in advance
Cyber_youngwomanindistress!
4 answers
-
If possible:
{ ={ DATE \@ "yyyy" }+1}
(to add the new braces: Ctrl+F9 then press F9 to "refresh", 2009 should appear!)-
Hi Captainvince, I hope you're still around here or that someone can answer my question...
I'm also looking for that miracle field that allowed me to create posters for D+1.
I’m creating an announcement that says "tomorrow, D+1 April general power cut"
I tried the syntax that Vince suggests, but Word returns a syntax error.
Thanks in advance to everyone. -
-
Thank you Raymond,
I have indeed succeeded with this formula in numeric.
Today on day 16, I managed to change it to 17.
However, when I replace d with dddd, it initially gives me { =Wednesday + 1} and then during the second switch, this error: !Undefined bookmark, WEDNESDAY.
Where is the problem, doctor? -
-
-
-
Hello,
I would say that, as a rule, it's not possible: Word can perform simple calculations based on the cells of a table, but I don’t see how to make it calculate based on some "random" numerical data.
To display today's date only in the year format, the best option is to go to Insert>Fields...>Date and select the format from the list provided (or, at worst, set it manually to "yyyy").
Otherwise, to display the year +1 or +2, I think the best approach would be to develop a small macro and attach it to a button. But it only makes sense if you need it often: entering the result manually is often the quickest in the end! -
I fully endorse Fourvin's comments. Word is not designed for this kind of manipulation, which even causes problems in Excel.
--
A retiree in the sun of the Antilles :-)
Raymond -
Hello everyone,
captainvince: and if you open it in 2010, what does it display please?
eric
