Thread: Week Ending Formula
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_276_] mudraker[_276_] is offline
external usenet poster
  
Posts: 1
Default Week Ending Formula
Jako

This will give next Saturday's date

dDate = DateValue(Now()) + (7 - WeekDay(Now())

--
Message posted from http://www.ExcelForum.com

Reply With QuoteReply With Quote