Easy Workday Question Need Help

pennynikkel · Mar 30th, 2004, 07:05 PM

Hi:

This will probably be an easy one for you... I have start date of May 19, 2003, and want to have a formula to enter the end date (45 working days later, should be July 18th).

I have start date in D3, and 45 in H3 and =WORKDAY(D3,H3), but get July 21st as the result, but it should be July 18th (I'm not worried about holidays).

What am I doing wrong?
TIA

Edited to be 2003

Joe4 · Mar 30th, 2004, 07:08 PM

The formula looks right to me (should be 7/21/04).

How can July 18th, 2004 be correct? That is a Sunday, which is NOT a workday.

pennynikkel · Mar 30th, 2004, 07:11 PM

Sorry, I should edit my original...I am looking at 2003, not 2004.

Joe4 · Mar 30th, 2004, 07:14 PM

Keep in mind that it does not count the current day. Hence, if you want to, you will need to subtract 1, i.e.:
=WORKDAY(D3,H3-1)

pennynikkel · Mar 30th, 2004, 07:17 PM

That worked, sorry...I new it would be a simple one.

Thanks.

Joe4 · Mar 30th, 2004, 07:18 PM

No need to apologize! We are here to help!

Mar 30th, 2004, 07:05 PM	#1
pennynikkel Join Date: Sep 2003 Posts: 38	Easy Workday Question Need Help Hi: This will probably be an easy one for you... I have start date of May 19, 2003, and want to have a formula to enter the end date (45 working days later, should be July 18th). I have start date in D3, and 45 in H3 and =WORKDAY(D3,H3), but get July 21st as the result, but it should be July 18th (I'm not worried about holidays). What am I doing wrong? TIA Edited to be 2003

Mar 30th, 2004, 07:08 PM	#2
Joe4 MrExcel MVP Moderator Join Date: Aug 2002 Posts: 14,114	Re: Easy Workday Question Need Help The formula looks right to me (should be 7/21/04). How can July 18th, 2004 be correct? That is a Sunday, which is NOT a workday. __________________ TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder.

Mar 30th, 2004, 07:11 PM	#3
pennynikkel Join Date: Sep 2003 Posts: 38	Re: Easy Workday Question Need Help Sorry, I should edit my original...I am looking at 2003, not 2004.

Mar 30th, 2004, 07:14 PM	#4
Joe4 MrExcel MVP Moderator Join Date: Aug 2002 Posts: 14,114	Re: Easy Workday Question Need Help Keep in mind that it does not count the current day. Hence, if you want to, you will need to subtract 1, i.e.: =WORKDAY(D3,H3-1) __________________ TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder.

Mar 30th, 2004, 07:17 PM	#5
pennynikkel Join Date: Sep 2003 Posts: 38	Re: Easy Workday Question Need Help That worked, sorry...I new it would be a simple one. Thanks.

Mar 30th, 2004, 07:18 PM	#6
Joe4 MrExcel MVP Moderator Join Date: Aug 2002 Posts: 14,114	Re: Easy Workday Question Need Help No need to apologize! We are here to help! __________________ TIPS FOR FINDING EXCEL SOLUTIONS 1. Use the built-in Help that comes with Excel/Access 2. Use the Search functionality on this board 3. A lot of VBA code can be acquired by using the Macro Recorder.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode