Thread: weekday last year
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default weekday last year
Hi Rob,

Am Thu, 25 Apr 2013 10:08:31 -0700 (PDT) schrieb Rob Nance:

What day of the week was it on today's date last year?

try:
=TEXT(DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY())),"dddd")


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote