| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching Quarters
I have the first column with various dates.
Col A July 07 Feb 08 Apr 08 May 08 Oct 08 Nov 09 and so on. What I want to do in col B - is to convert the dates to fall into any of the following quarters December , March, june,September This is what I want Col B to look like corresponding to column A June 07 Dec 07 March 08 march 08 September 08 September 09 Is there a formula which can give the dates automatically in column B |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching Quarters
see response to later posting
-- Regards Roger Govier "LR" wrote in message ps.com... I have the first column with various dates. Col A July 07 Feb 08 Apr 08 May 08 Oct 08 Nov 09 and so on. What I want to do in col B - is to convert the dates to fall into any of the following quarters December , March, june,September This is what I want Col B to look like corresponding to column A June 07 Dec 07 March 08 march 08 September 08 September 09 Is there a formula which can give the dates automatically in column B |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Matching Button for MS Excel 2007 or later | Excel Worksheet Functions | |||
| E_MAIL WITH MATCHING... | Excel Discussion (Misc queries) | |||
| working out quarters (three-month periods) between two dates | Excel Worksheet Functions | |||
| Otto M. - Data Matching | Excel Worksheet Functions | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
