IF and OR staements?

[kerry78]

HI!

Here is my spreadsheet

Column B: startdate (displayed as dd-mm-yyyy)
Column C: Weekday (displayed as serial_number)
Column D: my result (displayed as dd-mm-yyyy)
Column P: holidays (displayed as dd-mm-yyyy)


I need to figure out how to write a formula so that excel wil
understand to get my result...
So in column D, i need to put a formula something like this:

if C5 is equal to 7 or 8, or P515, then result is next availabl
business day
(result needs to be displayed as dd-mm-yyyy)

How do i write this formula?

****************************
Example:
B5= 04-09-2004 (september 4th, 2004)
C5= 7 (saturday)
D5= result should be september 7th, 2004 (tuesday)
**************************************
see attached
Thanks a bunch!

Attachment filename: automatic kvm calculator.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=66771

 

[Frank Kabel]

Hi
use the WORKDAY function for this. e.g.
=WORKDAY(B1,1,P515)

Note: You have to install the Analysis Toolpak Add-in for this

 

[kerry78]

the formula "works" as it gives result of 2 which is a tuesday, but whe
i cange the format (dd-mm-year) it returns 02-01-1900...

i need result of sept 7, 2004 (07-09-2004)

????

 

[Frank Kabel]

Hi
changing the format should not alter the result. what are the exact
values you have entered and what is the exact formula you have used?

 

[kerry78]

my bad.... i used B1 instead of B5- it works!!! thanks!