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

Formula

Excel Help for Formula in Analyzing Corporate Financial Data


Forum TopicLogin

Formula

Rate this:
(3/5 from 1 vote)
ConfusedThis is the formula I tried:
=IF(ISBLANK(Q45),"",IF(WEEKDAY(Q45)<=WEEKDAY(K45),Q45-K45-2,OR(IF(WEEKDAY(Q45+7)<=WEEKDAY(K45),Q45-K45-4,Q45-K45))))

It only subtracts 2 in any scenario.  Any suggestions??

Thanks
 Posted by on
 
View Full Post

Excel templates and solutions matched for Formula:

Solutions: Technical Analysis Functions Download Market Data File Comparison Bar Code Generator Spreadsheet Auditing Business Planning Templates Marketing Planning Financial Formula Calculations Technical Indicators Spreadsheet Link Checking Input Cell Solver Energy Conversion Useful Add-ins Conditional Rules Formula Analyzer Functions and Formulas Copy Protection Fix Broken Links Formula Cheat Sheet Formula Auditing Data Recovery
Categories: Excel Productivity Market Data Access Sales and Marketing Navigation and Auditing