View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
HFST04 HFST04 is offline
external usenet poster
 
Posts: 6
Default Account aging formula using workdays M-F

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