Thread: Returning Every friday value in a series of dates
View Single Post
  #2  
Old 07-04-2009, 04:39 PM
shg's Avatar
shg shg is offline
Forum Guru
  
Join Date: 20 Jun 2007
Location: The Great State of Texas
MS Office Version:2003, 2007
Posts: 18,550
shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay shg makes giving solutions look like childsplay
Re: Returning Every friday value in a series of dates
For the Friday on or after the date in column A, in K4 and copy down,

=A4 + MOD(6 - WEEKDAY(A4), 7)
__________________
Entia non sunt multiplicanda sine necessitate.
Reply With Quote