Display day of a date

[Pradeep Kumar .P]

Dear friend,

1). My query is very sinmple that, in a cell if am typing
a date (25-07-2003), then I want the day of that date
(Friday) should be displayed in the cell where I want to
display.

2). I calculated a figure (2500.00) in a cell, I want to
display the figure in words (Two thousand five hundred
only) in a cell where I wanted to.

I hope you will do the needful at the earliest.

Thanks & Regards

pradeep Kumar .P

 

[Ron de Bruin]

With the date in A1, place this in B1
=TEXT(A1,"dddd")

Read this posting for 2)
http://groups.google.com/groups?hl=...=1&[email protected]

 

[JMay]

Another Approach?:
With the date in A1, place this in B1
=CHOOSE(WEEKDAY(A1,2),"Monday","Tuesday","Wednesday","Thursday","Friday")

 

[Norman Harker]

Hi!

And another:

=WEEKDAY(A1)
Formatted dddd

This is a serendipitous approach that works as long as the date in not
before 31-Mar-1900 and results from the 29-Feb-1900 error.

Also:

=A1
Formatted dddd

First approach has advantage of storing the Day of Week number. Second
approach has advantage of storing the date serial; number.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Holidays and Observances Friday 25th July: Barundi (Anniv of 7th
Republic), Cook Islands (Rarotonga: Gospel Day), Costa Rica
(Guanacaste Day), Cuba (National Revolution), Ecuador (Foundation of
Guyaquil Day), Faroe Islands (Vestanstevna), Haiti (Papa Ogou),
Puerto Rico (Constitution Day), Spain (Galicia National Day, Santiago
Day, St. James Day), Tibet (Yalong Cultural Festival), Tunisia
(Republic Day). Observances: Voudon (Papa Ogou St Jacques le Majeur).
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

Another Approach?:
With the date in A1, place this in B1
=CHOOSE(WEEKDAY(A1,2),"Monday","Tuesday","Wednesday","Thursday","Frida
y")

With the date in A1, place this in B1
=TEXT(A1,"dddd")

Read this posting for 2)

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&c2coff=1&selm=uUmNMWfTDHA