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

[delene_tabone]

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?

[kersplash]

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

[humdingaling]

type in today's date instead?

[delene_tabone]

I have now attached sample work sheet and expected results

[delene_tabone]

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

[protonLeah]

Maybe:

Please Login or Register  to view this content.

[kvsrinivasamurthy]

In J4 then drag across

Please Login or Register  to view this content.