workday function only populate if there is a value

MG.MVG · #1 05-23-2016, 03:28 PM

I have a workday function that I have used for a column of cells, I only want it populated when there is a value in the start date field

jeffreybrown · #2 05-23-2016, 05:36 PM

Try...

=IF(N(A1),WORKDAY(A1,1),"")

...with A1 being the start date field

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Restrict Editing function disable insert textbox function	IanM_01	Word	5	11-21-2015 02:29 AM
#REF! Error in calling VBA function disappears when function is copied	lcaretto	Excel Programming	2	05-26-2014 07:19 PM
Subtracting dates workday function	gbaker	Excel	2	03-25-2014 11:43 AM
showing calendar days by keeping normal workday calendar	ketanco	Project	11	11-01-2013 08:27 AM
Using WORKDAY with fractional day lengths	Scaffold	Excel	11	06-29-2011 07:52 AM