Subtracting dates: 8/31/05-8/1/05?
 

I am trying to subtract the current date from the last business day of
the month, both being business days only.

So today is 7/26/05 and last business day is 7/29/05, so
7/29/05-7/26/05 = 3 days.

I have one cell with the current date. So that cell minus last business
day equals the balance of the month. Any help is appreciated, thanks.


--
dstock
------------------------------------------------------------------------
dstock's Profile: http://www.excelforum.com/member.php...o&userid=24225
View this thread: http://www.excelforum.com/showthread...hreadid=390198

Try this
=ABS(NETWORKDAYS(A1,A2))-1

HTH
Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=390198