WORKDAY formula giving 1 day extra - Please Help!!

[S1010]

Hi all,
WORKDAY formula looks so simple but it is not giving my desired result. Can someone suggest please.

Project duration-------------- Start Date--------------------- End Date
(No. of days)
1 ------------------ Friday, August 01, 2014 ------------------ Monday, August 04, 2014

My desired result is to see ' Friday, August 01, 2014 ' in end date.

Thanks!!

[sktneer]

Assuming A2 is Project Duration (1 in this case) and B2 is Start Date (01/08/2014 i.e. Friday, August 01, 2014 in this case), then try this......

=WORKDAY(B2,A2)

The above formula will return 04/08/2014 i.e. Monday, August 04, 2014.

[S1010]

Hi Sktneer,
yes, this is what is happening. but My desired result is to see ' Friday, August 01, 2014 ' in end date. Because 1 day task should finish within one day (start & end date should be same).

[sktneer]

Hi Sktneer,
yes, this is what is happening. but My desired result is to see ' Friday, August 01, 2014 ' in end date. Because 1 day task should finish within one day (start & end date should be same).

The Workday excludes the start date while calculating the workdays, so if you want to include the start date also, you may use it like this......

=WORKDAY(B1,A1-1)

[boopathiraja]

Hi, You mean this ?

=WORKDAY(B2-1,A2)

[sktneer]

In the formula suggested above, I assumed your data is in row1, so change the row reference as per your need.
Or if your data is in row 2, try this.....

=WORKDAY(B2,A2-1)

[Glenn Kennedy]

WORKDAY counts the start date as day zero, so you need to subtract 1 from the answer...

[S1010]

Great!! Thank you everyone.

[sktneer]

Glad we could help.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.

[S1010]

Added 'reputation' for all as thank u.