Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple question - help please and thank you.
Hey,
I am calculating simple monthly returns on a series of daily asset prices for a number of years worth of data. The problem is I am not sure how to indentify the end of a month, and the start of the next in a column of 05/01/2006 format sequential dates. I could just add another column and use the "month" function in excel (what I have done thus far), but I have to do the whole operation in VBA. What I have now is: If ActiveSheet.Cells(dayofmonth, 1) = ActiveSheet.Cells(dayofmonth - 1, 1) Then day +1 and continue till they are different etc...... The first column is a single number derived from a = month(date column) formula This unfortunately will not cut it. I want to be able to do the same operation, but not have to use the month function in excel - just reference the date column (04/09/2006 format). I am pretty sure I need to use a ActiveCell.Formula and a month function, but am unsure as to how to write the formula - any help would be tremendously appreciated. Regardless of how easy it is, I have sweat over this for some time....... Thanks - cheers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
Simple question | Excel Discussion (Misc queries) | |||
Simple Question | Excel Programming | |||
simple question, hopefully a simple answer! | Excel Programming |