Posted to microsoft.public.excel.misc

Tufail

external usenet poster

Posts: 168

Workday Error #VALUE!

Hello,
I am using this formula in cell D1 =IF($A1="","",WORKDAY(B1,C1))
B_1 has Date and C-1 has credit days value like 10 and i want Due Date in
D_1 cell but problam is that whenever B_1 doesn't have any value then #VALUE!
error is coming out which i really don't want !
Thanks in advance.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
WORKDAY	[email protected]	Excel Worksheet Functions	8	November 30th 07 06:36 PM
Workday Formula?	Fernbars	Excel Discussion (Misc queries)	6	June 7th 07 12:37 PM
27-May-2007 is a WORKDAY?	[email protected]	Excel Worksheet Functions	4	May 30th 07 09:24 PM
WORKDAY() and probably more	Epinn	New Users to Excel	19	September 24th 06 01:19 PM
Workday Help	mhart210	Excel Discussion (Misc queries)	3	July 10th 06 03:20 PM

All times are GMT +1. The time now is 10:15 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us