Hello,
I hope you're all well. I'm facing annoying problem and couldn't find any solution on the web. I have template which is sent on regularly basis to people all over the world. This template includes dynamically calculated dates (starting with one month forward):
excel1.PNG
My region is polish so "RRRR" stands for year and everything is fine. However that's what is seen by receivers from Italy, Greece, England...etc:
excel2.PNG
Now, when I change "RRRR" to "AAAA" which stands for year in Italy the receiver from Italy can see the dates correctly:
excel3.PNG
Is there any way to unify this so both sender and receiver see the same value in that particular format?
Bookmarks