Link (to Excel cell) Field Date Formatting Showing Incorrect Year

		Microsoft Office Forums > Microsoft Word > Word
Link (to Excel cell) Field Date Formatting Showing Incorrect Year

06-15-2023, 12:32 PM

eyefuel

Windows 10 Link (to Excel cell) Field Date Formatting Showing Incorrect Year

Office 2021

Novice

Join Date: May 2023

Posts: 2

The cell is actually a formula - EOMOnth(D5,-1). If I apply the format M/dd/yyyy it displays 5/31/2022.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Empty date cell shows wrong month & year	Learner7	Excel	3	06-16-2019 11:09 AM
changing only year component in a date field using vba	Zhibek	Word VBA	5	08-16-2018 01:29 AM
Baseline Slippage showing incorrect date	jim44	Project	0	04-29-2018 06:05 PM
Year date not showing at bottom of chart.	snowboarder2	Excel	4	02-28-2017 05:13 PM
How to calculate a rolling year-to-date percentage by quarter as the year progresses	sleake	Excel Programming	2	04-23-2015 11:51 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:28 AM.