ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Custom Calendar Format (https://www.excelbanter.com/excel-programming/334406-custom-calendar-format.html)

robertjtucker[_3_]

Custom Calendar Format
 

What I am wanting to do is create a custom calendar format. Like the
Gregorian you put b1 before the date format "b1dd/mm/yy" or the Hijri
"b2m/d/yyyy. I want to create a calendar format that relates to our
manufacutring schedule for instance the month of January is Jan1-Feb5.
So when I put the actual date in a cell it will give me our
manufacturing month and year.
Thanks for the help.
Bob


--
robertjtucker
------------------------------------------------------------------------
robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805
View this thread: http://www.excelforum.com/showthread...hreadid=386807



All times are GMT +1. The time now is 07:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com