Hi All
I am banging my head against a wall, for something i believe is relatively simple.
I am using the above code, which will work fine Tuesday - Friday to advise if the value in BQ is yesterday, but i need to adapt it to expand the scope on monday, to ask BQ on monday if -1 is a friday.'=IF(BQ161694=TODAY()-1,"use","ignore")'
I hope that makes sense :-)
Thanks.
You want the Workday function
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
I would just use
=IF(BQ161694=TODAY()-IF(WEEKDAY(TODAY())=2,3,1),"use","ignore")
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
