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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

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:11 PM.