calculate in a yet unknown range

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

fanny - 09 Feb 2007 20:03 GMT

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

Reply to this Message

tristan.huxley@prox-e-mics.eu - 13 Feb 2007 12:29 GMT

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!

> Hi,
> I want to calculate weeks based on days. Days are in column H, weeks should
[quoted text clipped - 9 lines]
>
> Fanny

Reply to this Message