Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|