Comparing cells with text to cells with numeric values.

's Computer Specifications

I am manually entering an abrv. day of the week in one cell and need to
compare that to a formula generated day of the week in another cell in a what
if statement. At this point I have been unable to figure out how to make the
two cells communicate.
--
David B

's Computer Specifications

This will return a three character abbreveation using any date

WeekdayName(Weekday(DateValue("4/25/08")), abbreviate:=True)

"David B" wrote:

> I am manually entering an abrv. day of the week in one cell and need to
> compare that to a formula generated day of the week in another cell in a what
> if statement. At this point I have been unable to figure out how to make the
> two cells communicate.
> --
> David B

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Comparing cells written in text to cells producing text from a for	David B	Microsoft Excel Programming	1	28th Apr 2008 07:20 PM
Exclude #N/A values and Return Numeric values to consecutive cells in Single Row	Sam via OfficeKB.com	Microsoft Excel Worksheet Functions	5	9th Feb 2008 03:07 AM
Comparing Values from 2 cells	=?Utf-8?B?UmVnZ2ll?=	Microsoft Excel Programming	2	13th Dec 2005 07:51 PM
Iterating through cells, comparing values	kingpin2502	Microsoft Excel Programming	0	11th Jul 2005 06:08 PM
Comparing values in non contigious cells	thePriest	Microsoft Excel Programming	3	3rd Mar 2005 05:21 AM