Thread
:
mm/dd/yy vs Mon, Tue, Wed etc
View Single Post
#
6
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
mm/dd/yy vs Mon, Tue, Wed etc
pinmaster,
assuming your days in B1:H1 are abreviated (Sun, Mon...etc) then:
if so then you don't need the LEFT() Function:
=IF(TEXT($A2,"ddd")=B$1,"Yes","No")
--
Regards,
Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings
with @tiscali.co.uk
"pinmaster" wrote in message
...
Hi,
Another way:
assuming your days in B1:H1 are abreviated (Sun, Mon...etc) then:
=IF(LEFT(TEXT($A2,"dddd"),3)=B$1,"Yes","No")
if (Monday, Tuesday...etc)
IF(TEXT($A2,"dddd")=B$1,"Yes","No")
copied across and down
HTH
Jean-Guy
"Ken" wrote:
Excel2003 ...
Col A contains dates ... Format = mm/dd/yy
Cols B thru H contain ... Text = Mon, Tue, Wed, Thu, Fri, Sat, Sun
I wish to format & setup so I can have a formula under each day of the
week
that will peg the day vs the mm/dd/yy date in Col A.
If Col A = 01/17/07 ... No-No-Yes-No-No-No-No ... (Yes = Weds)
If Col A = 01/19/07 ... No-No-No-No-Yes-No-No ... (Yes = Fri)
If Col A = 03/05/07 ... Yes-No-No-No-No-No-No ... (Yes = Mon)
Thanks ... Kha
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann