Stopping a count of days when a date is entered

[Araujo1958]

Slight dilema which I am sure is very simple for the majority of XL users to solve. I have a spreadsheet which is populated with 20+ columns, some dates, times and dropdown lists. It also incorporates the Today() function. At the moment when a start date is entered into column H, column G calculates the lapsed time from that column to "todays" date based on the function "NETWORKDAYS". The problem I have is that I want the count to stop for that row when an end date is entered into column L. Hope that I have represented this in an understanderble manner.

Many thanx in advance

[DonkeyOte]

Perhaps you want something along the lines of:

Please Login or Register  to view this content.

[TMS]

It would help if you posted a sample workbook.

It sounds as though you'd need a VBA Worksheet Change Event to monitor the input in column L; when you put in the end date, it would change the formula to use the date in column L rather than Today's date.

Regards

[TMS]

But, as ever, DonkeyOte has offered a neater solution. ;-)

[Araujo1958]

Slight dilema which I am sure is very simple for the majority of XL users to solve. I have a spreadsheet which is populated with 20+ columns, some dates, times and dropdown lists. It also incorporates the Today() function. At the moment when a start date is entered into column H, column G calculates the lapsed time from that column to "todays" date based on the function "NETWORKDAYS". The problem I have is that I want the count to stop for that row when an end date is entered into column L. Hope that I have represented this in an understanderble manner.

Many thanx in advance

Just one other quick point if I may is there a simple add-in to the formula that would make the figure it dissappear once a value is entered into column L? (even if it's some form of conditional formatting)
Once again thank you

[DonkeyOte]

If you're saying you don't want any numeric result should Col be complete then:

Please Login or Register  to view this content.