Hi!

Figure out what is a day 01/01/xxxx. Add required number of days to it to get to Friday. Then add 7 days to it in a loop till the end of the year. Note that {date value} + {number} = {date value increased by number of days}. Use DOW() function to get day of week for given date.

HTH.

>Hi all,
>
>I want to create an array with a list of week ending dates (Friday).
>Anyone know the easiest way of doing this?
>
>Thanks in advance,
>
>Ger.