Thread: Date Function formula that will return the date of a specific week
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Toppers
 
Posts: n/a
Default Date Function formula that will return the date of a specific week
try:

=TODAY()+7-WEEKDAY(TODAY())

"Greg" wrote:

I am trying to set up a date field in a spreadsheet that will always give the
date of the upcoming Saturday. I have tried the "Weekday" function along with
the "If" and the "If/Or" statements without success. Can someone help?
Reply With QuoteReply With Quote