F
fanny
Hi,
I want to calculate weeks based on days. Days are in column H, weeks should
come in column I, a so far empty column. I don't know the amount of rows in
H (days). I put in a macro Worksheets("sheet1").Activate,
ActiveCell.CurrentRegion.Select, because if want for each activated
worksheet the same lay-out (bounders). But this doesn't work for formula's.
So, it should be a formula which says something like: as long as the value
in whatever cell in column H (to begin with H,2) is equal to or greater than
0, tell me this value in weeks (days/7) for the cell in column I in the
corresponding row.
Anybody who can help me??
Fanny
I want to calculate weeks based on days. Days are in column H, weeks should
come in column I, a so far empty column. I don't know the amount of rows in
H (days). I put in a macro Worksheets("sheet1").Activate,
ActiveCell.CurrentRegion.Select, because if want for each activated
worksheet the same lay-out (bounders). But this doesn't work for formula's.
So, it should be a formula which says something like: as long as the value
in whatever cell in column H (to begin with H,2) is equal to or greater than
0, tell me this value in weeks (days/7) for the cell in column I in the
corresponding row.
Anybody who can help me??
Fanny