Djblois
01-26-2007, 08:27 AM
I am trying to get the amount of weeks between 2 dates and this is what I tried but I just get the number that Excel uses to represent dates. I this possible? THis is the date I am using:
Range("K" & i).FormulaR1C1 = "=RC[-6]-R[1]C[-6]/7"
I would also like to get the amount of weeks between today's date and the first date. Here is the code I tried for that:
Range("K" & i).FormulaR1C1 = "=Today-RC[-6]/7"
Range("K" & i).FormulaR1C1 = "=RC[-6]-R[1]C[-6]/7"
I would also like to get the amount of weeks between today's date and the first date. Here is the code I tried for that:
Range("K" & i).FormulaR1C1 = "=Today-RC[-6]/7"