Thread: I need to display "Good Morning" or "Good Evening" based on NOW()
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default I need to display "Good Morning" or "Good Evening" based on NOW()
=IF(NOW()-TODAY()0.5,"good evening", "good morning")

--
Gary''s Student - gsnu200735
Reply With QuoteReply With Quote