How to start counting the number of days up from a [Start Date] column, but ending it when the job i

Paul Newcome

=NETWORKDAYS([Kick Off Date]@row, IF(ISDATE([Live Date]@row), [Live Date]@row, [Projected Live Date]@row))

 

Give this a shot...

JenM.

Bingo! Much thanks for your help with this formula. 

Paul Newcome

Happy to help. 

JenM.

Eeeek sorry to come back to this, I must have lost something in translation. 

My goal was to have the "Number of Days" column be a counter, counting number of work days (NETWORKDAYS) starting from the Kick Off Date but not going on forever, but ending on the "Live Date" when that date is entered. OR if a date has to be entered for the counter to stop, then I can make that date the "Projected Live Date"

*please don't throw anything at me :S

 

Paul Newcome

If I am understanding what you are saying then the formula above should work. It basically says to calculate the NETWORKDAYS starting with the Kickoff Date and ending with the Live Date if one is entered. If there is no Live Date entered, it will display how many days between the Kickoff and the Projected Live Dates.

 

Is that not quite it?

JenM.

I think I am try to accomplish something a bit different.

to calculate the NETWORKDAYS starting with the Kickoff Date and ending with the Live Date if one is entered. If there is no Live Date entered, it will display how many days from Kickoff an the present day (so I can see how far along it is) Not to display the number of days between the Kickoff and Projected live. 

 

Paul Newcome

=NETWORKDAYS([Kick Off Date]@row, IF(ISDATE([Live Date]@row), [Live Date]@row, TODAY()))

 

Got it. Sorry about that. Try this one.

JenM.

No need to apologize. Thank you so much for working with me (who is new with SS) to develop a formula that works for the task - more learning is required on my part. Much thanks!

Paul Newcome

No worries at all. Happy to help.