Home > Forum Home > Analyzing Corporate Financial Data > Nested IF Statement - Subtract Weekend Days > Additional Info Share

Additional Info

Excel Help for Additional Info in Analyzing Corporate Financial Data

Forum TopicLogin

Additional Info

Rate this:
(3/5 from 1 vote)
ConfusedThank you for the response - it was helpful.

What if the dates are greater than one week apart?  i.e an invoice was approved on Jan 6 and processed on Jan 18.  In this scenario, I would like to subtract 4 from the total.  Is there a condition that could be added to the formula to account for this?  Possibly:
Again, I would like this included in the original formula so that the formula is constant throughout the spreadsheet.

Thanks again!
 Posted by on
View Full Post

Find relevant Excel templates and add-ins for Additional Info in the