![]() |
|
#1
|
|||
|
|||
![]()
The cell is actually a formula - EOMOnth(D5,-1). If I apply the format M/dd/yyyy it displays 5/31/2022.
|
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
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 |
![]() |
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 |