Thread: Converting Dates to Week Ending time period
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Converting Dates to Week Ending time period
On Fri, 20 Jun 2008 06:18:01 -0700, 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!



=A1+7-WEEKDAY(A1+1)


--ron
Reply With QuoteReply With Quote