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 Formula Management File Comparison Financial Ratio Calculations Bar Code Generator Employee Timesheet Productivity Add-ins Spreadsheet Auditing Business Planning Templates Marketing Planning Financial Formula Calculations Technical Indicators Spreadsheet Link Checking Input Cell Solver Energy Conversion Useful Add-ins Change Formula References 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