>>Hi all,
>>
>>Is there a quick way to get the week of month given a date?
>>
>>example.
>>sep 04
>>s m t w t f s
>> 1 2 3 4 - week 1
>>5 6 7 8 9 10 11 - week 2
>>12 13 14 15 16 17 18 - week 3
>>19 20 21 22 .... - ...
>>oct 04
>> 1 2 - week 1
>>3 4 5 6 7 8 9 - week 2
>>...
>>
>week()
>To be more clear:
>?Week(ldDate)-Week(Date(Year(ldDate),Month(ldDate),1))+1
>Cetin
Thank you. The formula works.
ramil
~~ learning to stand still