View Single Post
  #1   Report Post  
Old May 19th 18, 05:39 PM
crowleysmoose crowleysmoose is offline
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