ExcelBanter
(
https://www.excelbanter.com/
)
-
Excel Discussion (Misc queries)
(
https://www.excelbanter.com/excel-discussion-misc-queries/
)
- -
Date to change format
(
https://www.excelbanter.com/excel-discussion-misc-queries/195624-re-date-change-format.html
)
Jarek Kujawa[_2_]
Date to change format
presuming item1 is in A1, try:
=MONTH(A1)&"/"&YEAR(A1)
All times are GMT +1. The time now is
05:12 PM
.
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com
