Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Is there a way anyone can help me try and convert the date when I enter it
into something like this below: 07-I-01-01, 07-II-04-01, 07-III-07-01 or 07-IV-10-01 Where the year comes first then the number in which Quarter it belongs to and then the month broken by the date. The Quarters are devided up as follows .... 01-Jan-Mar, 02-Apr-Jun, 03-Jul-Sep, 04-Oct-Dec. Your help is really appreciated and thnak you for help in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Create a formula in a date range to locate a specific date - ecel | Excel Discussion (Misc queries) | |||
Report Date - Date Recv = Days Late, but how to rid completed date | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel |