Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA for Month and Quarters Output
Hi, I am new to writing in VBA, but I would like to write a function, where the inputs are a start date and an end date (month&year), and the output is a range in a single row of an indefinite number of columns (to be determined by how muhc time is between the starting date and the ending date). I would like the output to be in the form of showing the month and year, and at the end of every fiscal quarter showing the quarter and year. For example the output would look like the following, where a comma shows where a break between cells in a row occurs: "Jan-2009, Feb-2009, Mar-2009, Q1-2009, Apr-2009,..." Any tips would be greatly appreciated. I assume I will have to write this as a function not a subroutine, but would appreciate hearing suggestions. Thanks! -- Hugo |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quarters | Excel Worksheet Functions | |||
Set of varibles produces one output. Need series of output. | Excel Programming | |||
working out quarters (three-month periods) between two dates | Excel Worksheet Functions | |||
End of the 4 quarters | Excel Discussion (Misc queries) | |||
Getting output from an excel output back to cscript.. | Excel Programming |