Excel formula to check whether there are weekends

[EinarOSies]

Please I have this record

Please I would want an excel formula to check whether the last inputted date in Column A(I used the formula "=LOOKUP(2,1(A:A<>"",A:A" to get the last last date in Column A) and today("=TODAY()" contains weekends, if it does then it should remove the number of weekend days from the days between. I initially used this formula "=TODAY()-LOOKUP(2,1/(A:A<>""),A:A)" to calculate the days between the last date and the current date but I have a downside of excluding weekends.



Please any suggestion on how to remove the number of weekend days?



Einar

 

[TylerWhieler]

Hi there,

I'm guessing you would like the formulla in F30?
The formula u want is: (Days between dates - weekends)*Running hours?

If yes then:

=NETWORKDAYS.INTL(A30;TODAY();1)*E30

Hope it helps, GL