Determine day of week in text format
I have a date "mm/dd/yy" in A1. How do I determine the day in text format
for B1, ie Sunday, Monday, etc. Thanks, Les |
Determine day of week in text format
=TEXT(A1,"dddd")
-- John C "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
Determine day of week in text format
or
=A1 Formatted as dddd Mike "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
Determine day of week in text format
In article ,
WLMPilot wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les Try... =TEXT(A1,"dddd") Hope this helps! |
Determine day of week in text format
Thanks!
"John C" wrote: =TEXT(A1,"dddd") -- John C "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
Determine day of week in text format
Thanks!
"Mike H" wrote: or =A1 Formatted as dddd Mike "WLMPilot" wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les |
Determine day of week in text format
Thanks!
"Domenic" wrote: In article , WLMPilot wrote: I have a date "mm/dd/yy" in A1. How do I determine the day in text format for B1, ie Sunday, Monday, etc. Thanks, Les Try... =TEXT(A1,"dddd") Hope this helps! |
All times are GMT +1. The time now is 05:40 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com