|
|
|
|
#1
12-10-2015, 07:24 PM
|
|||
|
|||
Adding Formula
Hi,
Still don't get it. Here i attached the spreadsheet. If you see cell C6, its counting 7 inclusive of weekends. How can i exclude the weekends without messing up the current formula? Please help 
|
|
#2
12-17-2015, 04:27 AM
|
|||
|
|||
|
Try this:
=IF(ISBLANK(E6),TODAY()-B6,NETWORKDAYS(B6,E6,$F$6:$F$18))
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
 Adding Months
|
TimmiAndrew | Excel | 2 | 09-16-2015 10:21 AM |
|
adding a red box
|
jolinchew | Word | 8 | 07-12-2013 11:46 PM |
|
Adding Image into a excel cell and adding a hyperlink to the image
|
saravananiyyanar | Excel | 3 | 05-04-2011 08:31 AM |
|
Adding PDF
|
sussertown | Office | 2 | 06-13-2009 01:10 AM |
Windows 7 64bit 
Office 2007
Hybrid Mode