Macro help using Date()

[Mully]

Hi wonder if anybody can help, how would I set up a macro array for this were there are 13 periods and 52 weeks, 1 period = 4weeks.

Example basic
IF Date() => 05/05/2005 and Date()=< 11/05/2005 THEN Period = 1 Week =1

 

[Legacy 98055]

Hi Mully.

Please clarify some things for us.

05/05/2005 and 11/05/2005 are May 5th to May 11th? Correct?

When does your fiscal year begin? Is your leap year counted at the beginning or end of your fiscal year...

Thanks,

Tom

 

[Mully]

Hi Tom,

Sorry I never got an email saying that you replied.

1 st Quater
Week ending Sat
Period 1
5 March wk1
12 March wk2
19 march wk3
25 march wk 4

Period 2
2 April wk6

etc.

Regards Mully.