Djblois
02-12-2007, 08:33 AM
At the present moment I am creating a temporary column "O" with today's date and then I do math based on that cell:
Range("O" & i).FormulaR1C1 = "=Today()"
Range("E" & i).FormulaR1C1 = "=(RC[10]-RC[1])/7"
RC[10] Refers to the Today column. However is it possible to combine these two formulas into one to save on steps. I want to subtract the date in column -RC[1] by the today column RC[10] and then divide it by 7.
Thank you all for your help
Range("O" & i).FormulaR1C1 = "=Today()"
Range("E" & i).FormulaR1C1 = "=(RC[10]-RC[1])/7"
RC[10] Refers to the Today column. However is it possible to combine these two formulas into one to save on steps. I want to subtract the date in column -RC[1] by the today column RC[10] and then divide it by 7.
Thank you all for your help