Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Link (to Excel cell) Field Date Formatting Showing Incorrect Year
Register FAQ

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #3  
Old 06-15-2023, 12:32 PM
eyefuel eyefuel is offline Link (to Excel cell) Field Date Formatting Showing Incorrect Year Windows 10 Link (to Excel cell) Field Date Formatting Showing Incorrect Year Office 2021
Novice
Link (to Excel cell) Field Date Formatting Showing Incorrect Year 		 
Join Date: May 2023
Posts: 2
eyefuel is on a distinguished road
Default
The cell is actually a formula - EOMOnth(D5,-1). If I apply the format M/dd/yyyy it displays 5/31/2022.
Reply With Quote
 

« Previous Thread | Next Thread »


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link (to Excel cell) Field Date Formatting Showing Incorrect Year 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
Link (to Excel cell) Field Date Formatting Showing Incorrect Year 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 08:31 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft