Oh! I forgot the Workday() function. THanks for reminding
Ajit
On Tue, Oct 7, 2008 at 8:03 PM, Ajay Varshney
<[EMAIL PROTECTED]>wrote:
> Check the formula from attached file.
>
> You should use Workday formula
>
> Regards,
> Ajay Varshney
>
> On Tue, Oct 7, 2008 at 12:45 AM, sanj <[EMAIL PROT
Adding working days to a date is not full-proof, as you can consider only
Saturday and sundays as non-working days and not public holidays. Still try
using the weekday() function in an IF(). Based on the value returned by
weekday() (sat or sun) add appropriate number of days to the date. If you
hav
Check the formula from attached file.
You should use Workday formula
Regards,
Ajay Varshney
On Tue, Oct 7, 2008 at 12:45 AM, sanj <[EMAIL PROTECTED]> wrote:
>
> I have a date in a1; in a2 I want to add 2 working days.
> As per example: 3rd Oct, 2008 + 2 working days = 7th October, 2008
>
> It w