Business Technology Microsoft Excel Tutorial – How to convert a number to relevant weekday name? December 4, 2022December 4, 2022 Usman Zafar Paracha 0 Comments business, education, Microsoft Excel, tutorialThis post contains information/formula for Microsoft Excel to convert a number to relevant weekday name. Check more information here on SayPeople.com Formulae to convert a number to relevant weekday name Dynamic connector.761 example example Rectangle =TEXT(DATE(2017,1,A1),"dddd") =TEXT(DATE(2017,1,A1),"dddd") Rectangle.746 Formulae to convert a number to relevant weekday name Formulae to convert a number to relevant weekday name Dynamic connector.748 Dynamic connector.749 example example Dynamic connector.750 gives gives 2-D word balloon Assuming that the number is mentioned in A1 Assuming that the number is mentioned in A1 Dynamic connector.762 gives gives Rectangle.765 =TEXT(DATE(2017,1,A1),"ddd") =TEXT(DATE(2017,1,A1),"ddd") Dynamic connector.766 2-D word balloon.769 “ddd” is to get three letters weekday name “ddd” is to get three letters weekday name 2-D word balloon.770 Suppose, you want to set 1 for Sunday, 2 for Monday, 3 for Tu… Suppose, you want to set 1 for Sunday, 2 for Monday, 3 for Tuesday, and so on, until 7 for Saturday 2-D word balloon.772 Year 2017 has been selected as its first day, 1-Jan-2017, was… Year 2017 has been selected as its first day, 1-Jan-2017, was Sunday — Year 2023 also starts with sunday 2-D word balloon.774 “dddd” is to get full weekday name “dddd” is to get full weekday name Sheet.30 Sheet.31 Sheet.32 Sheet.33 Related
