calculate the number of days opened

[dasugarbabe74]

Hi

I am trying to calculate the number of days an issue has been opened. I used the fomula below with this details

=NETWORKDAYS(E6,$E$1)


date opened
24/04/2008

But instead of getting '9' days . I am getting '-28264'

Can anyone help please.

thanks

[oldchippy]

Hi,

With NETWORKDAYS you need a start date and an end date, presumably you do not have a date entered in E1? To get 9 you need 06/05/2008 in E1

[dasugarbabe74]

Well, I dont have an end date as of yet and I am trying to make it calculate days opened to current date.

thanks

[oldchippy]

Hi,

In E1 put

=TODAY() does that work for you?

[dasugarbabe74]

Yes it did.

Thanks a million

[daddylonglegs]

You could leave E1 blank until you have an end date to put in there. This formula will calculate until today while E1 is blank then use the date in E1 once inserted

=NETWORKDAYS(E6,IF(ISNUMBER($E$1),$E$1,TODAY()))