New to Excel functions and need some help
 

Hello all.

I tried search and was not able to find what I was looking for.

This is what I am trying to do:

Have time sheets and they are kind of a bear.

I have the date column formatted to read -Weekday, Month Day, Year-.

Now, lets say that I enter -Friday, June 9, 2006- at the source cell.

In a following cell, I want it to evaluate the source cell for the
weekday only. That way, I can instruct the cell to take an action if
the entered weekday is Monday as opposed Friday.

Any thoughts? I am just overlooking something way too simple?

Thanks a bunch!

-Barry


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409

New to Excel functions and need some help
 

Barry --

If the initial date is in A1, you can use

=WORKDAY(A1,1)

to get the next work day. The function allows you to set up a range of
holiday dates, and bypass those as well as weekends.

HTH

"Barry Clark" wrote:


Hello all.

I tried search and was not able to find what I was looking for.

This is what I am trying to do:

Have time sheets and they are kind of a bear.

I have the date column formatted to read -Weekday, Month Day, Year-.

Now, lets say that I enter -Friday, June 9, 2006- at the source cell.

In a following cell, I want it to evaluate the source cell for the
weekday only. That way, I can instruct the cell to take an action if
the entered weekday is Monday as opposed Friday.

Any thoughts? I am just overlooking something way too simple?

Thanks a bunch!

-Barry


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409

New to Excel functions and need some help
 

Hello PDBerger.

I have tried things like that and I only get #name? as a return.


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409

New to Excel functions and need some help
 

Barry --

What version of Excel are you using? When they went from 2000 to 2003, I
remember they changed some of the names. If you're using 2000, use help to
look at Date & Time functions.

HTH

"Barry Clark" wrote:


Hello PDBerger.

I have tried things like that and I only get #name? as a return.


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409

New to Excel functions and need some help
 

Hey Barry...

The reason that you are getting the Excel error is that you do not have the
WORKDAY function enabled... in order to use this function, you must enable
the Analysis ToolPak, generally the core installation of Excel does not
include all functions to be enabled, to take advantage of these extrat
capabilities, you need to select ToolsAdd Ins and then select the Analysis
Toolpak... this will eliminate the Excel error #NAME?...
--
Thanks for your help -
Joe Mac


"pdberger" wrote:

Barry --

What version of Excel are you using? When they went from 2000 to 2003, I
remember they changed some of the names. If you're using 2000, use help to
look at Date & Time functions.

HTH

"Barry Clark" wrote:


Hello PDBerger.

I have tried things like that and I only get #name? as a return.


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409

New to Excel functions and need some help
 

haha. Now that I have enabled Analysis Toolpak, I get #Value.

Anyways, I am using 2003. I still have not been able find away to use
the sheet name as a cell value.


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile: http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409

New to Excel functions and need some help
 

You need to use numeric values, else you get value errors

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"Barry Clark"
wrote in message
...

haha. Now that I have enabled Analysis Toolpak, I get #Value.

Anyways, I am using 2003. I still have not been able find away to use
the sheet name as a cell value.


--
Barry Clark
------------------------------------------------------------------------
Barry Clark's Profile:
http://www.excelforum.com/member.php...o&userid=35267
View this thread: http://www.excelforum.com/showthread...hreadid=550409