| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Days open Calculation
I am using =NETWORKDAYS(A2,B2) for days open
How can i modify the above formula so it will pickup Todays's date if there is no date in B5. Can anybody help ASAP with that......... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Days open Calculation
Hi,
Am Wed, 31 Dec 2014 17:17:38 +0000 schrieb GRS6411: I am using =NETWORKDAYS(A2,B2) for days open How can i modify the above formula so it will pickup Todays's date if there is no date in B5. in C2 try: =NETWORKDAYS(A2,IF(B2=0,TODAY(),B2)) and copy down Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
|
#3
|
|||
|
|||
|
It worked.Thank you very much.
Am Wed, 31 Dec 2014 17:17:38 +0000 schrieb GRS6411: I am using =NETWORKDAYS(A2,B2) for days open How can i modify the above formula so it will pickup Todays's date if there is no date in B5. in C2 try: =NETWORKDAYS(A2,IF(B2=0,TODAY(),B2)) and copy down Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional[/quote] |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| days calculation | Excel Discussion (Misc queries) | |||
| days calculation | New Users to Excel | |||
| days calculation | Excel Programming | |||
| How to calculation no. of days (only working days) between two dat | Excel Discussion (Misc queries) | |||
| Please Help With Days Elapsed And Days Remaining Calculation | Excel Worksheet Functions | |||
Linear Mode
