Re: How to calculate time difference excluding weekends (saturday andsunday) On Apr 30, 2:21 pm, Ken Denny <k...@kendenny.com> wrote:
<snip>
> Assuming that date2 is the later date and that neither date falls on a
> Saturday or Sunday, this should do it:
>
> date2 - date1 - 2*(trunc(next_day(date2-1,'FRI')) -
> trunc(next_day(date1-1,'FRI')))/7
</snip>
Ken,
Thank you so much..this works perfectly.
Deepak |