6 day workday calculations

[baddipu]

hi ,

am a new user, i would like to know the formula to add days to date excluding holidays and sundays only (and include Saturday as working day) without the need of analysis toolpack.

any suggestions please.

[Bryan Hessey]

hi ,

am a new user, i would like to know the formula to add days to date excluding holidays and sundays only (and include Saturday as working day) without the need of analysis toolpack.

any suggestions please.

Hi,

the Workday requires (as you are aware) the Analysis Toolpak, otherwise you could test if the Day of the date you want to add to is Saturday (day 7) and add 2, else add 1.

=IF(WEEKDAY(E5)=7,E5+2,E5+1)

hth
---

[Bryan Hessey]

Hi Bryan,

thanks for ur suggestion.

what i want exactly is, i want to derive a date say, 10th day from today, the result should show the 10th business day which excluding sundays and holidays only and include saturday as working day. using workday() function, its working but bydefault the system calculates saturday as weekend.

can u help me in this function.

no further suggestions to date.
---