Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I need a formula that calculates the working days (A) from start to todays
date and (B) from start to completion. I also don't want a value displayed until at least one date is entered so it doesn't corrupt my avg formula. I'm currently using =IF(AND(D3="",C3=""),"",IF(D3="",TODAY()-C3,D3-C3)) in column C and it returns the values listed below. I want it to return only working days. A B C 4/15/10 4/23/10 8 4/20/10 3 Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Aging Formula Help | Excel Worksheet Functions | |||
Aging Formula | Excel Discussion (Misc queries) | |||
Aging Formula | Excel Discussion (Misc queries) | |||
aging formula | Excel Discussion (Misc queries) | |||
WHAT FORMULA DO I USE FOR AGING A STATEMENT | Excel Worksheet Functions |