Blank Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

NotGood@All - 27 Mar 2008 00:00 GMT

I have 2 date fields, B30 & C30 and a number field F30. I want to calculate
the Net Workdays between B30&C30 putting the answer in F30, but if C30 is
blank, I want F30 to be blank. I used this code in F30
“=IF(C30="","",NETWORKDAYS(C30-B30))” but I can’t get it to work. Would
someone please help me!

Signature

NotGood@All

Reply to this Message

David Biddulph - 27 Mar 2008 00:03 GMT

If you look up NETWORKDAYS in Excel help it will tell you the syntax of the
function.
--
David Biddulph

>I have 2 date fields, B30 & C30 and a number field F30. I want to
>calculate
> the Net Workdays between B30&C30 putting the answer in F30, but if C30 is
> blank, I want F30 to be blank. I used this code in F30
> "=IF(C30="","",NETWORKDAYS(C30-B30))" but I can't get it to work. Would
> someone please help me!

Reply to this Message

Ron Coderre - 27 Mar 2008 00:07 GMT

Sometimes Excel Help can be...helpful:
NETWORKDAYS(start_date,end_date,holidays)

Your formula doesn't use the correct function arguments:
=IF(C30="","",NETWORKDAYS(C30-B30))

If
C30 is the start_date
and
B30 is the end_date,

the formula should be:
=IF(C30="","",NETWORKDAYS(C30,B30))

Does that help?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

Reply to this Message

Tyro - 27 Mar 2008 00:15 GMT

Did you put quotes around your formula? If so, remove them. Also, the
NETWORKDAYS format is NETWORKDAYS(StartDate,EndDate[,Holidays]) Your formula
has a "-" sign in it as in C30-B30. NETWORKDAYS wants a comma between C30
and B30 as in =NETWORKDAYS(C30,B30) If you are using a version of Excel
prior to Excel 2007, you need to have the Analysis Toolpak installed to use
the function NETWORKDAYS. You don't state what happens when you use the
formula. "can't get it to work" doesn't tell anybody anything.

Tyro

Reply to this Message

NotGood@All - 28 Mar 2008 18:27 GMT

Thank you all for helping me! The problem was the "-", should have been ","

Signature

NotGood@All

> Did you put quotes around your formula? If so, remove them. Also, the
> NETWORKDAYS format is NETWORKDAYS(StartDate,EndDate[,Holidays]) Your formula
[quoted text clipped - 12 lines]
> > "=IF(C30="","",NETWORKDAYS(C30-B30))" but I can't get it to work. Would
> > someone please help me!

Reply to this Message