if statements returning dates

C

Clinton

i have the following formula to give a 2 day cycle for production which will
skip saturdays and sundays. can it be made to miss other days such as public
holidays also if they are put into a table or something.

IF(WEEKDAY(A1+2)=7,A1+4,IF(WEEKDAY(A1+2)=1,A1+4,A1+2))

where: A1 is first date, formula is in B1:Z1
 
F

Fred Smith

Yes it can if you use NETWORKDAYS. You will need to have the Analysis
ToolPak installed, unless you have XL2007. Look it up in help for more
information.

Regards,
Fred.
 
T

T. Valko

See Excel help on the WORKDAY function.

It returns the date serial number n days if the future and has an option to
account for holidays.

You have to format the result as a date.
 
C

Clinton

thank you very much. worked perfect.

T. Valko said:
See Excel help on the WORKDAY function.

It returns the date serial number n days if the future and has an option to
account for holidays.

You have to format the result as a date.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Search closest day in the past from today 2
returning a date 7 business day excluding holidays in the future 2
Problem using IF statement with dates as part of the formula 4
Week ending Thursday formula 4
Future date with six day week including holidays 1
How to start week numbering (WEEKNUM) on a certain day? 3
Help with an if then scenario 2
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3

Top