I like it!
--

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"vezerid" wrote in message
...
One way: for a date in A2, next Friday:

=CEILING(A2+1,7)-1

HTH
Kostis Vezerides

On Jun 20, 4:18 pm, drew wrote:
I am trying to convert a specific date to a Week Ending value. The week
starts on Saturday and ends on Friday for this example.

So.. any value from 6/14 through 6/20 would return a value of week ending
6-20-2008. Any suggestions? Thanks!