Question about Microsoft Excel for PC

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 on

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

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.

×

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

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

×

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

Hi,
Thanks & Regards,
Anil

Posted on Oct 01, 2010

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

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.

×

×

my-video-file.mp4

×

Related Questions:

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

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"

Jun 23, 2011 | Microsoft Excel for PC

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

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

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

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

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

Regarding Excel formulas

Yes, its possible by designing a formula in excel.

Aug 03, 2008 | Microsoft Windows XP Professional

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

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

332 views

Level 3 Expert

Level 3 Expert