Microsoft Office Forums - View Single Post - [Solved] workday function only populate if there is a value

Thread: [Solved] workday function only populate if there is a value

View Single Post

Old

05-23-2016, 05:36 PM

jeffreybrown jeffreybrown is offline

jeffreybrown is offline

jeffreybrown uses Windows Vista

Windows Vista jeffreybrown uses Office 2007

jeffreybrown uses Office 2007

Office 2007

Expert

Join Date: Apr 2016

Posts: 673

jeffreybrown has a spectacular aura about

jeffreybrown has a spectacular aura about

Default

Try...

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

...with A1 being the start date field

Reply With Quote