Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with TEXT function, returning wrong day.
Hello. I'm having difficulties with the TEXT function, it is returning the wrong day for a date.
B2 Contains the following: 03/08/2017 The function is: =TEXT(B2,"dddd") I checked the actual calendar and it was Sunday, but it's returning Thursday for some reason. Can anyone help me out pleaaase :0 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help with TEXT function, returning wrong day.
Hi,
Am Sat, 19 May 2018 17:39:00 +0100 schrieb crowleysmoose: Hello. I'm having difficulties with the TEXT function, it is returning the wrong day for a date. B2 Contains the following: 03/08/2017 The function is: =TEXT(B2,"dddd") I checked the actual calendar and it was Sunday, but it's returning Thursday for some reason. my calendar shows for the 3rd August 2017 THURSDAY. Regards Claus B. -- Windows10 Office 2016 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUMPRODUCT Returning 0 or wrong totals | Excel Worksheet Functions | |||
xlChart returning wrong value | Excel Programming | |||
OFFSET function in named range returning wrong # of rows | Excel Worksheet Functions | |||
Round/Ceiling on an IF function returning numerical value or text | Excel Worksheet Functions | |||
VLOOKUP returning wrong row | Excel Worksheet Functions |