View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default formula for finding Friday

Just another option:
=A1+MOD(138612,WEEKDAY(A1)+6)

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"EdStevens" wrote in message
oups.com...
Looping through a series of cells with dates, need to compute from the
given date the date of the following Friday. If the given date *is*
Friday, I need that date returned, not the date of the Friday of the
following week.

Thanks.