New to Excel functions and need some help

B

Barry Clark

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 th
weekday only. That way, I can instruct the cell to take an action i
the entered weekday is Monday as opposed Friday.

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

Thanks a bunch!

-Barr
 
P

pdberger

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
 
B

Barry Clark

Hello PDBerger.

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

pdberger

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
 
J

Joe Mac

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 Tools>Add Ins and then select the Analysis
Toolpak... this will eliminate the Excel error #NAME?...
 
B

Barry Clark

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.
 
Top