Count number of days from a start date to today BUT end at a certain date

Hi All,

first time posting here so let me know if i dont give enough information.

Basically i need a formula to count the number of days from a start date - until today BUT stop at an end date.

At the moment my formula looks like this:

=NETWORKDAYS(A13,TODAY())

i need to add onto that an end date.

So basically if A13 = 04/06/2018, i want it to count the number of days until today which is 3 days but after today i want it to STOP counting (hence need to add an end date). So when i go in to the spreadsheed tomorrow the answer is still 3 days.

Is this possible?

Is the end date fixed and able to be calculated from your start date?

If that's the case you should be able to do what you want.

Attach a small sample workbook showing your data and mock up your expected results.

Go Advanced -> Manage Attachments -> Upload

I have now attached sample work sheet and expected results

Hi humdingaling ,
Yes i had considered this however I have ALOT of data and am trying to make my worksheet as automated as possible. This will be my manual work around if i have no other choice