Hi Vikram,
The Workday() function return the next working day after the specified no
of days it excludes the weekends and the days you have specified as the
holidays.
for example if i write: =WORKDAY(DATEVALUE("11/1/2012"),10) the will return
11/15/2012 because there will be weekends on 3,4 and 10 ,11 nov.
And also pls note:
Dates should be entered by using the DATE function
A positive value for days yields a future date; a negative value yields a
past date.
Prince dubey
Hope this will help you .
Regards
On Sunday, 29 July 2012 13:33:42 UTC+5:30, vic kumar wrote:
>
> H,
>
> Please help regarding how to implement workdays formula.
>
>
> --
> Regards,
>
> Vikram Ahuja
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited.
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
------------------------------------------------------------------------------------------------------
To post to this group, send email to excel-macros@googlegroups.com
To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
