New to Excel functions and need some help

[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 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

[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

"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
>
>

[Barry Clark]

Hello PDBerger.

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

Also, I would like to derive a value from the sheet name.

Say I have a spread sheet of dates. The dates won't change year to year, but the year, of course, will. Is there something like =January 01, (see sheet name for year) I can enter into a source cell? If so, if I tell the subsequent cell to read that source cell and add 1, will it return a January 02 date?

thank you.

[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

"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
>
>

[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?...
--
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
> >
> >

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

[Peo Sjoblom]

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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>