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

Hi Fanny,

I am going to attempt to answer this for you, but am not really sure
of what you are asking for... So I am making the assumption, that you
have a date in cell H2!

So I would suspect that you would want something like

=IF(H2>0,DAY(H2),0)

The DAY() function will only show the day of the month, so if the date
was 10/02/07, it would say the DAY() as 10... If it happens to be the
difference from another date, you would simply have it as =IF(H2>0,H2-
[Other Cell Referene],0)

If this is not what you are after, please feel free to contact me

Good Luck!


On Feb 10, 7:03 am, "fanny" <f.klomp...@chello.nl> wrote:
> 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