Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default Dates | Excel Discussion (Misc queries) | |||
Using dates for x-axis values as string instead of creating a scale | Charts and Charting in Excel | |||
subtracting dates to get a age | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) | |||
Dates Subtracting dates. | Excel Discussion (Misc queries) |