John Wesley
-
From: Krishna madolli
To: excel-macros@googlegroups.com
Sent: Thu, February 9, 2012 4:34:17 AM
Subject: Re: $$Excel-Macros$$ Next Working date
Hi Srinivas,
You can try this formula:
=IF(WEEKDAY($A$1)=7,A1+
Hi Srinivas,
You can try this formula:
=IF(WEEKDAY($A$1)=7,A1+DAY(2),IF(WEEKDAY($A$1)=6,A1+DAY(3),A1+DAY(1)))
On 2/9/12, Chidurala, Shrinivas wrote:
> Dear Group,
>
> Please suggest any formula to pick next working date, but Saturday and
> Sunday should not include.
>
> Working day Next
Hi Shinivas,
=Workday(A2,1,0)
See the attached
On Thu, Feb 9, 2012 at 1:14 PM, Chidurala, Shrinivas <
shrinivas.chidur...@citi.com> wrote:
> **
>
> Dear Group,
>
> Please suggest any formula to pick next working date, but Saturday and
> Sunday should not include.
>
>*Working day* *Next Worki
Dear Group,
Please suggest any formula to pick next working date, but Saturday and Sunday
should not include.
Working day Next Working day
9-Feb-12 10-Feb-12
10-Feb-1213-Feb-12
Regards,
Shrinivas
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise