weekday last year

C

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?
Click to expand...

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


Regards
Claus Busch
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need some PWA help 0
may need programming? 2
Dates In Excel 5
Search closest day in the past from today 2
Template with fields and premade texts.. 0
Why am I getting this error? 0
Task Information Dialog Box not making duration changes to task 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0

Top