ChrisAcheson
05-25-2017, 07:39 AM
Hi All
I am banging my head against a wall, for something i believe is relatively simple.
'=IF(BQ161694=TODAY()-1,"use","ignore")'
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.
I hope that makes sense :-)
Thanks.
I am banging my head against a wall, for something i believe is relatively simple.
'=IF(BQ161694=TODAY()-1,"use","ignore")'
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.
I hope that makes sense :-)
Thanks.