View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken Ken is offline
external usenet poster
 
Posts: 590
Default Formula ... Minus Holidays?

Excel2003 ... I have an inherited spread sheet (ahhhhhhhh) which I am trying
to unravel. The following formulas work, but now I need to exclude Holidays:

Cell F121 ... contains a Date (format = mm/dd)
Range F12:F120 ... contains Formulas (format = Date = mm/dd)
Range E12:E120 contains number of days (format = Number = 0.00)

Cell F12 ... =IF($F$121="","",$F$121+SUM($E12:$E$120))
Cell F13 ... =IF($F$121="","",$F$121+SUM($E13:$E$120))
Cell F14 ... =IF($F$121="","",$F$121+SUM($E14:$E$120))
etc ... (Please note shrinking "E" Range)

Issue ... I wish to write Formula to exclude the Holidays found in Range
E12:E120???

Thanks for the guidance ... Kha