PDA

View Full Version : Date / Business Date



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.

mdmackillop
05-25-2017, 08:22 AM
You want the Workday function

xld
05-26-2017, 03:39 AM
I would just use

=IF(BQ161694=TODAY()-IF(WEEKDAY(TODAY())=2,3,1),"use","ignore")