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

Re: How can I count the number of SATURDAYS in a month? 0
returning a date 7 business day excluding holidays in the future 2
CALCULATE BETWEEN TWO DATES EXCLUDING WEEKENDS 3
Future date with six day week including holidays 1
Calculating how many Saturdays there are between two given dates 6
number or working days 6
formulas to count dates 2
Networkdays and misleading results from blank column 3

Top