| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
weekday last year
What day of the week was it on today's date last year?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
weekday last year
On Thursday, 25 April 2013 18:08:31 UTC+1, Rob Nance wrote:
What day of the week was it on today's date last year? Thx Claus. Seems to work. Will find out for sure tomorrow :) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combination Graph with current year and prior year sales | Charts and Charting in Excel | |||
| Which historical year will offer the same weekday ... ? | Excel Discussion (Misc queries) | |||
| WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
| WEEKDAY question on year | Excel Discussion (Misc queries) | |||
| Xth Weekday of the Month/Year | Excel Programming | |||
Linear Mode
