Hi All,

I have manipulated some data and managed to get the week number of each row
and the day of that week (a number from 1 to 7, 1 = monday, 7 = sunday) in
any particular year.

e.g. for today (27 Mar 2007):
week number = 13
year = 2007
day = 2 (2 for tuesday).

Using this data, is there anyway i can return the actual date for today
(e.g. 27-Mar-07) using a formula ?

Any help would be much appreciated.

Regards,

Bhupinder.