Microsoft word insert date with 18 months added on

[steve wilson]

Hi,
I as wondering if it is possible to add 18 months onto a date in Microsoft word 2010.

I can get it to add 1.5 years onto the years, but can not get it to display in the format I want.

{={DATE \@ "dMyyyy" }+1.5 \# "## # ####"}

All that this returns is "17 5 2015"

With today's date being 17-05-2013, the date I want to get to is 17-11-2014. The "+1.5" part is adding one and a half years on, but it only effects the year part of the date. It doesn't add 18 months onto the whole thing.

This is for putting 18 months shelf life on frozen products in case anyone is curious.

 

[Tweak155]

The only way I could get this to work was to insert an excel spreadsheet, shrink it down to the size of 1 cell and then put in the formula =NOW() + 540

That Word editor sucks! Good luck.

 

[EagleKeeper]

Change the system date forward, generate labels and reset the date back

 

[steve wilson]

Thanks for the suggestions.