MrExcel Message Board


Go Back   MrExcel Message Board > Question Forums > Excel Questions

Excel Questions All Excel/VBA questions - formulas, macros, pivot tables, general help, etc. Please post to this forum in English only.

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
Old Mar 30th, 2004, 07:05 PM   #1
pennynikkel
 
Join Date: Sep 2003
Posts: 38
Default 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
pennynikkel is offline   Reply With Quote
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT +1. The time now is 02:07 AM.


Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
All contents Copyright 1998-2009 by MrExcel Consulting.