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 shrinivas.chidur...@citi.com wrote:
Dear Group,
Please suggest any formula to pick next working date, but Saturday and
Sunday should not include.
Wesley
-
From: Krishna madolli kmado...@gmail.com
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
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
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 Working day*
