| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Custom Calendar Format Example Jan 1-Feb 5 is Jan
I was wanting to know if it is possible to create a custom calendar like the Gregorian or the Hijri. When they use those formats they put a b1 or b2 infront of the format like b1mm/dd/yyyy. I want to be able to key a date in a cell and it gives me the business month not the actual month, unless it falls that way. This is a maunfacturing calendar and isn't standard for business reasons. Just hoping this is possible. Thanks for all the help. -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=387126 |
|
#2
|
|||
|
|||
|
Use a custom format of \bm mm/dd/yyyy
-- HTH Bob Phillips "robertjtucker" wrote in message news:robertjtucker.1s5uqg_1121346315.7975@excelfor um-nospam.com... I was wanting to know if it is possible to create a custom calendar like the Gregorian or the Hijri. When they use those formats they put a b1 or b2 infront of the format like b1mm/dd/yyyy. I want to be able to key a date in a cell and it gives me the business month not the actual month, unless it falls that way. This is a maunfacturing calendar and isn't standard for business reasons. Just hoping this is possible. Thanks for all the help. -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=387126 |
|
#3
|
|||
|
|||
|
Can you explain a little -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=387126 |
|
#4
|
|||
|
|||
|
In the cell where you key in the date, goto FormatCellsCustom and set that
custom format. -- HTH Bob Phillips "robertjtucker" wrote in message news:robertjtucker.1s60ad_1121353539.6635@excelfor um-nospam.com... Can you explain a little -- robertjtucker ------------------------------------------------------------------------ robertjtucker's Profile: http://www.excelforum.com/member.php...o&userid=21805 View this thread: http://www.excelforum.com/showthread...hreadid=387126 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom percent format needed | Excel Worksheet Functions | |||
| custom format & saving | Excel Discussion (Misc queries) | |||
| Keep custom format in new worksheet | Excel Discussion (Misc queries) | |||
| How do I format a cell for a custom part number? | Excel Discussion (Misc queries) | |||
| Custom Format for ¢ | Excel Discussion (Misc queries) | |||
Hybrid Mode
