>Hi,
>
>Do you have a function that can return the last day of the week if a pass the number that is returned from the Week()?
>
>For eg: if I pass 31 to the function , I should get 07/31/2004, which is the last day of that week.
>
>TIA
While there may be a more straightforward way, in the past I have simply written a loop to do something similar. In your case, your UDF could might just continue incrementing a date variable, until you get to Saturday.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)