Thread: Help with looking the nearest Sunday
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default Help with looking the nearest Sunday
=TEXT(A13+LOOKUP(WEEKDAY(A13),{1,2,3,4,5,6,7},{0,-1,-2,-3,3,2,1}),"mm/dd/yyyy")


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



"JR" wrote in message
...
Hi,

I currently use this formula to populate teh nearest Friday to today:

=TEXT(A13+LOOKUP(WEEKDAY(A13),{1,2,3,4,5,6,7},{-2,-3,3,2,1,0,-1}),"mm/dd/yyyy")

How do I change the formula so that it will caluclate the nearest Sunday?

Thanks for the help.


Reply With QuoteReply With Quote