Error handling (check if the cell is current week)

[mumsys]

Hi, im doing an error handling to my project. I get some problems :/:

On sheet 1 there is a table that is being downloaded in a scheme that You see.

A) I need to check if a date in cell (28,14) - 15.2013 is a current week.
B) The problem is that this cell is number stored as text :/
C) Second problem is that when the week will be first of the year or second etc. It will show as 1.2013 and 2.2013 (because i wanted to use "Left(Cells(28,14),2)"

If my problem is not clear enough tell me and i will explain further

[Debraj Roy]

How you decide month in case its 23.2013

[oeldere]

You can also make the current week as text and then compare them.

How you gonna compare them.

If it isn't text, what would be in the cell to your opinion.

15.2013 (format as genareal)?

[mumsys]

Thx for the answers.
Debraj Roy, i dont decide which month. In this case today would be 32 week of a year. This example has some old weeks in it
So it should be a workbook downloaded from week 32 to week 41 and my macro need to check if the current week (32) is the same in cell (28,14)

Oeldere, so Youre saying there is no difference if its number stored as text? I thought that this would be an issue.

[oeldere]

if you make the current week as text, it will find the current week with text in your file. (since the format is equal).

maybe that's not the best solution, but then we have to know what you gonna do with your file.

compare (how) / all cells / one cell etc.

[Debraj Roy]

Try this...

Please Login or Register  to view this content.

which will try to convert..

15.2013 to 15 AUG 2013
and dateValue will convert 15 AUG 2013 to actual Date.. like 41501
and then a you can go for WeekNum Test..

Hope you can able to adjust Cells(28,14) with I,J and loop..

Try and confirm..

[mumsys]

compare only one cell (28,14) because if this is right all of the rest would be right.

The problem is that if i define as string -

Please Login or Register  to view this content.

it will show 32.2013 and then compare with the cell (28,14) it will be ok.
But if the current_week would be on the beginning of the year it would be current_week = 01.2013 (and in the report i will have 1.2013 - so it would be an error).

[mumsys]

Debraj Roy, thank You that managed to challenge my issue

[oeldere]

In that case you have to check the length of the cells (normaly 7, in the beginning of the year 6 characters).

[Debraj Roy]

15.2013 to 15 AUG 2013
and dateValue will convert 15 AUG 2013 to actual Date.. like 41501

In above case.. it will also take care.. if date is 01 / 1 / 11..

and thanks for the rep & feedback.. Mark as solved.. if solved..