weekday last year

[Rob Nance]

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

 

[Claus Busch]

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

 

[Rob Nance]

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

Thx Claus. Seems to work. Will find out for sure tomorrow