Question about Microsoft Office Standard for PC

Re: Excel

Hi HYBFS, Please give me a little more detail of what you are trying to achieve from this formula and I will be able to assist you. Thanks and regards DeltaC

Posted on Sep 13, 2007

The WorkDay Function returns a number that's the serial date that is the indicated number of working days from a given date (the starting date). Working days EXCLUDE weekends and any dates identified as holidays. Use WORKDAY to exclude weekends or holidays when you calculate invoice due dates, expected delivery times, or the number of days of work performed.

The Syntax is:

=WORKDAY(start_date,days,holidays)

where:

- start_date is in Date format (and can be a calculated value);

- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);

- holidays is an array of holidays you can specify if desired.

The Syntax is:

=WORKDAY(start_date,days,holidays)

where:

- start_date is in Date format (and can be a calculated value);

- days is a number of elapsed days after start_date (can be calculated, can be negative to indicate a date BEFORE start_date);

- holidays is an array of holidays you can specify if desired.

May 01, 2014 | Microsoft Excel for PC

Formulas are used to specify calculations based on values in designated cells. Excel supports basic calculations as well as statistical, trigonometric and other specialized functions.

Formulas used in Excel must follow a certain syntax.

- All formulas begin with an equals sign
**(=)**. - Some formulas use operands such as
**+,-, *,/**for addition, subtraction, multiplication or division.

For example, the formula =A1+A2+A3 would add the contents of cells A1, A2 and A3. - Other formulas refer to different functions such as SUM, AVERAGE and others.

For example, the formula =SUM(A1:A3) would add the contents for the range A1 through A3. - Formulas can be
**combined with operands.**

For example, the formula =10*SUM(A1:A3) would add the contents cells A1 through A3 and multiply them by 10. - Functions can
**be nested within each other.**

For example, the formula =SQRT(10*SUM(A1:A3)) would take the square root of ten times the sum of cells A1 through A3. When functions are nested, it is important that the number of left parentheses match the number of right parentheses.

Aug 19, 2011 | Microsoft EXCEL 2004 for Mac

This is too complicated for a help site like this, you are going to want to consult an excel forum, or some excel professional in your area. This is far beyond the scope of what you can expect for $15, which I'm sure you now realize after 10 days of trying.

Thanks

Tim

Thanks

Tim

Sep 26, 2010 | Microsoft Excel for PC

The inverse tan, or arctan in excel is

=ATAN(A1)

Change A1 to number or cell you want the inverse tan of

=ATAN(A1)

Change A1 to number or cell you want the inverse tan of

Jul 11, 2010 | Microsoft Excel for PC

Assuming the cell that you want to "test" is B1, the formula is:

=IF(WEEKDAY(B1,1)=7,TODAY()+2,TODAY()+1)

If this solves your problem, please rate me, thanks.

=IF(WEEKDAY(B1,1)=7,TODAY()+2,TODAY()+1)

If this solves your problem, please rate me, thanks.

Apr 05, 2009 | Microsoft Excel for PC

use the below formula to get the date of the LWD (Monday thru Friday) of the month.

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Assumed that if the date in cell A1 is 6-May-2005. then formula will be

=DATE(YEAR(A1),MONTH(A1)+1,0)-(MAX(0,WEEKDAY(DATE(YEAR(A1),MONTH(A1)+1,0),2)-5))

Jan 30, 2009 | Microsoft Excel for PC

It sounds like you want to determine the number of work days between two days? Use the NETWORKDAYS function. For example, if A1 is 1/4/09 and B1 is 2/4/09, =NETWORKDAYS(A1,B1) will be 23

Dec 18, 2008 | Microsoft Excel for PC

hello

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

yes it is.

example

sheet1

A1 (50)

A2 (50)

sheet2

(A1)=

"=Sheet1!A2+Sheet1!A1" <-this is the actually code in sheet2 column A1

ok let me explain

in A1 and A2 in sheet1 you got 50 and 50 like numbers.

in A1 on Sheet2 you have = sheet1 a1 + sheet1 a2.

did you get it?

dont know else how I should explain it...

good luck

Oct 09, 2008 | Microsoft Excel for PC

for example, cell A1 has date (01-01-2008) and cell A2 has current date (08-24-2008) and cell A3 shows total days, is that you want to know? if yes, apply formula as under...

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

cell A3......(properties set as General to show digits)................ =SUM(A2-A1)

Aug 25, 2008 | Microsoft Office Professional 2007:...

Yes...no....yes....and yes. And if that sounds like a funny response let me explain. First of all you can write a formula for a specific cell (or cells or interrelated cells where you menus would display). It takes a while and if you are new to the syntax it could take a couple hours even (let's assume you are not a math major). Using Access, for something this apparently simple, I would not suggest (another learning curve but admittedly a reasonably easy one). But, this is the second yes, the easiest way to do this would be to simply insert a "comment". When you hold the cursor over the cell...your data...i.e. menu...will pop up. And yes...(last yes) you could have Sunday thru Monday across the top and Breakfast, lunch and dinner in the right hand column. Now this assumes what you have said is what your are trying to do...effectively meal planning...and you are not trying to plug in the inventory in the fridge to develop a shopping list.

Lastly...yes I could write the formula....but not knowing what you do (and figuring if you are going to use Excel at all you really do need to learn how to do it) I would be wasting a bit of time. Hope this helps...Tango.

Lastly...yes I could write the formula....but not knowing what you do (and figuring if you are going to use Excel at all you really do need to learn how to do it) I would be wasting a bit of time. Hope this helps...Tango.

Feb 04, 2008 | Microsoft Excel for PC

Apr 25, 2014 | Microsoft Office Standard for PC

42 people viewed this question

Usually answered in minutes!

If Cell A1 says Yes need in Cell B1 to calculate the yes answer to = 1 so all yes answers can be calculated.

×