Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 19th 18, 05:39 PM
Junior Member
 
First recorded activity by ExcelBanter: May 2018
Posts: 1
Smile 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   Report Post  
Old May 19th 18, 06:01 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2011
Posts: 3,595
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SUMPRODUCT Returning 0 or wrong totals Rbirdie Excel Worksheet Functions 11 March 5th 10 07:05 PM
xlChart returning wrong value SixSigmaGuy[_4_] Excel Programming 9 July 29th 08 03:47 AM
OFFSET function in named range returning wrong # of rows Heidi Excel Worksheet Functions 5 March 20th 07 10:15 PM
Round/Ceiling on an IF function returning numerical value or text donnaK Excel Worksheet Functions 4 December 13th 05 04:20 PM
VLOOKUP returning wrong row jthomas Excel Worksheet Functions 6 August 3rd 05 10:32 PM


All times are GMT +1. The time now is 03:19 PM.

Powered by vBulletin® Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017