Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
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
Reply



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 01:22 PM.


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