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?