Stop days when a date is added to another Column

NP_32832

Hi, hoping for assistance!

I currently have a day counter formula:

=NETDAYS([Posted Date]@row, TODAY())

within a "Req Age" column. How do I stop counting days when a date is entered into my "hired date" column?

thank you!

Hollie Green

=if([hireddate]@row<>"",Netdays([Posted Date]@row,[hired date]@row),Netdays([posted date]@row,Today()))

NP_32832

Thank you @Hollie Green

Unfortunately, I'm getting the #unparseable error when entering that formula

NP_32832

@Hollie Green NVM, I figured it out. I just needed to add a space between hired and date. Thanks for your help!

Hollie Green

Excellent! Glad it worked for you. My space bar is difficult sometimes and doesn't actually accept the input.