Year +1 or Year +2
cyber_jeunefemmeendétresse
-
Raymond PENTIER Posted messages 58550 Registration date Status Contributeur Last intervention -
Raymond PENTIER Posted messages 58550 Registration date Status Contributeur 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 réponses
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 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
--
A retiree in the sun of the Antilles :-)
Raymond
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.
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?
If you enter 3/1/08 in a cell:
the d (or j) format displays 3
the dd (or jj) format displays 03
the ddd (or jjj) format displays Thu
the dddd (or jjjj) format displays Thursday
--
Retirement is great! Especially in the Caribbean... :-)
Raymond
In the formula, if I enter dddd, I can't get the result Wednesday if it's Tuesday or Saturday if it's Friday. What could that be?