Question about Microsoft Excel for PC

3 Answers

Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a holiday then the date display in B1 will be back day) Case 1, A1 input 1 Sep 10 then cell B 1 will display 15 Sep 10 because (A1 + 14 days = 15 Sep 10 and 15 Sep 10 is a working day). Case 2, A1 input 1 Sep 10 then cell B 1 will display 14 Sep 10 because (A1 + 14 days = 15 Sep 10 but 15 Sep 10 is a holiday therefore B1 cell will back day to a non holiday day). I think we need to create a holiday table to pre-set the date in other worksheet, check the holiday table before display the result in cell B1.

Posted by Anonymous on

  • 3 more comments 
  • Anonymous Sep 27, 2010

    would u show me the excel formula in B1 (e.g. =ifB1+14=range(A1:A20)...) and the holiday table we just need to input all holidays in one column?

  • Anonymous Oct 01, 2010

    Require to write an MS excel formula,
    Input a date in cell A1, write a excel formula in cell B1 to display A1 + 14 days & exclude holidays if B1 result is a holiday, i think we need to create a holiday table in other worksheet, everytime calculate cell B1 need to check holiday table, example 1, cell A1 input 1 Sep 2010, cell B1 display 15 Sep 2010 because 1 Sep + 14 days = 15 Sep & 15 Sep is not a holiday, sample 2, cell A1 input 1 Sep 2010, cell B1 display 14 Sep 2010 because 1 Sep + 14 days = 15 Sep & 15 Sep is a holiday in holiday table.

  • Anonymous Oct 01, 2010

    Dear Anibr,



    My email address is [email protected]



    Best regards,

  • Anonymous Oct 02, 2010

    Hello,



    Do you receive my email address, would u kindly provide your solution to me as early as possible because i've another excel question need to solve, Fixya request me to solve all previous question then allow me to post another question.



    Thank you for your support!



    Best regards,

  • Anonymous Oct 06, 2010

    Pls help to write an excel formula to display date, thanks! Cell A1 input a date - 1 Sep 10, Cell B1 write a formula to calculate & display the date which = (A1 + 14 days but if the result is a holiday then the date display in B1 will be back day) Case 1, A1 input 1 Sep 10 then cell B 1 will display 15 Sep 10 because (A1 + 14 days = 15 Sep 10 and 15 Sep 10 is a working day). Case 2, A1 input 1 Sep 10 then cell B 1 will display 14 Sep 10 because (A1 + 14 days = 15 Sep 10 but 15 Sep 10 is a holiday therefore B1 cell will back day to a non holiday day). I think we need to create a holiday table to pre-set the date in other worksheet, check the holiday table before display the result in cell B1.

×

Ad

3 Answers

Anonymous

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    President:

    An expert whose answer got voted for 500 times.

  • Master
  • 2,777 Answers

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

Posted on Oct 06, 2010

  • Anonymous Oct 11, 2010

    Please reconsider changing your rating of my answer. The 1 out of 4 thumbs up is really hurting my overall rating and I was just trying to be helpful here. :( Please do me this one favor and help me out.

    Thanks
    Tim

  • Anonymous Oct 12, 2010

    Please consider coming back to the site here and changing your thumb rating on my answer, it is really hurting my overall rating. Thanks

×

Ad

Balakrishnan Computers (A Computer Repair Shop)

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Guru:

    An expert who has written 7 tips or uploaded 3 video tips

  • Master
  • 468 Answers

Hi,
Left me know your email address, I will send a list of excel formulaes with instructions. It will be helpful in future also.
Thanks & Regards,
Anil

Posted on Oct 01, 2010

Ad

Rinoo Kumari

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Microsoft Expert
  • 2,973 Answers

You are right. You have to have a table of holidays and then compare the result in this table and then work the new date. Like "if B1 = range (here give the range of the holidays table, just one column is required) then B1 = (B1 - 1). Something on those lines.

Posted on Sep 27, 2010

  • Rinoo Kumari Sep 27, 2010

    I am using Open Office. And what is there in MS Office, OO has to be compatible with it.
    If is used as

    IF(Test; ThenValue; "OtherwiseValue")
    example IF (A1 <> value; B1 10 ; B1 9)
    Now the value of 'value' should be specified and can not be taken from the range in OO. I am not sure about MS Office. To achieve this we will have to use IF operator that many times as are the holidays with the operator OR. Example
    IF(A1 <> value1; B1 10 ; B1 9) OR
    IF(A1 <> value2; B1 10; B1 9)
    These are just two conditions. You can have as many as you want as are the holidays.
    Else you can try the range. It may work, you never know.

×

Add Your Answer

×

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Program that will accepts 2 numbers and will display the sum,difference,product and quotient by the use of flow chart?


You can do this pretty easily in a spreadsheet program such as excel, open office or numbers on a mac. Simply use two cells for the numbers you would like as an input and then input formulas for the sum, difference, product and quotient in 4 other cells. Examples:

(This assumes you use A1 and B1 to hold your input numbers)
For sum you would input the formula: =A1+B1
For difference: =A1-B1
For product: =A1*B1
For quotient: =A1/B1

To get this into a flowchart simply go into "Insert > Chart" and select the chart you want to use with the correct options.

I hope this helps, if it does, please give a thumbs up!

Jun 28, 2011 | Computers & Internet

1 Answer

I need a formula length of service in DD/MM/YY on MS Excell


Format cells A1 and B1 to dates.

A1 is the first date
B1 is the 2nd date
C1 enter the formula below

=DATEDIF(A1,B1,"y")&" years "&DATEDIF(A1,B1,"ym")&" months "&DATEDIF(A1,B1,"md")&" days"

rootmailsd.jpg

Jun 23, 2011 | Microsoft Excel for PC

2 Answers

Text within an IF formula


Use this formula in B1: =CHOOSE(A1,"GOOD","FAIR","BAD")
With this you must have 1, 2, or 3 in A1 or you will get a #VALUE error in B1.

May 20, 2009 | Microsoft EXCEL 2004 for Mac

4 Answers

Using excel to solve problem by trial and error method


In A1, put a random value of d as 0.1. Then in B1, put your equation 5*d^4 - 10.29*d^(-1.333), wherein refer d as A1. Then use goal seek function on Tools Menu. First "Set cell" as B1, "To value" as 0.124 and "By Changing Cell" as A1. Excel will do the Trial & Error and will give you the answer in Cell A1.

Nilesh

Mar 31, 2009 | Microsoft EXCEL 2004 for Mac

1 Answer

Multiply a value by a minimum amount


You need a cell to put these numbers first. Lets say A1 is your reference cell where the numbers are going to be input. B1 is the cell that you are going to see the calculation. Type the following formula in B1

=IF(A1<4,4*60,A1*60)

after doing this you can put any number in A1 and it will give you the calculation in B1 as the way you wanted.

Feb 24, 2009 | Microsoft Excel for PC

3 Answers

Need excel solution


Hello ycool11, If your asking what i think you are the formula would be
=(a2-a1)*24
That assumes a2 is that last date entered and a1 is the initial starting date. if you would like a more intense formula let me know and i'm sure i can help.

Oct 22, 2008 | Microsoft Excel for PC

1 Answer

Computer


Any formula in Excel starts with the equals sign ("="). This is how Excel distinguishes between formulas and literal values. Knowing this, you can create lots of formulas using the usual operators of +, -, * and / for addition, subtraction, multiplication and division, respectively. Please see the examples below.

Add 1 + 1: =1+1
Add the contents of cell A1 to the contents of cell B1: =A1+B1

Subtract 2 - 1: =2-1
Add the contents of cell A1 from the contents of cell B1: =B1-A1

Multiply 1 times 2: =1*2
Multiply the contents of cell A1 times the contents of cell B1: =A1*B1

I hope this resolves the question. If not, please let me know.

Aug 08, 2008 | Microsoft Computers & Internet

2 Answers

Regarding Excel formulas


Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

1 Answer

EXCEL FORMULA SOLUTATION FOR


hm I dont think that is possible with a formula. I think you need to use Macro.

Jul 18, 2008 | Microsoft Computers & Internet

1 Answer

Data validation in excel


instead of validation use conditional formating (under format menu). If c1<1 format cell as red. It does not have the attention getter that validation does not require the active cell event. Every other option requires the cell become active for a test.

Apr 13, 2008 | Computers & Internet

Not finding what you are looking for?

Open Questions:

See all Microsoft Excel for PC Questions

Microsoft Excel for PC Logo

332 views

Ask a Question

Usually answered in minutes!

Top Microsoft Computers & Internet Experts

efs_perpends
efs_perpends

Level 3 Expert

1997 Answers

k24674

Level 3 Expert

8092 Answers

Jax Planet
Jax Planet

Level 2 Expert

923 Answers

Are you a Microsoft Computer and Internet Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...