Can any one help how to get maximum high of given days excluding weekly off days (sat/sunday) from google finance.
I am using formula like: =query(GOOGLEFINANCE("NSE:"&Y3,"high",(TODAY()-55),TODAY()),"Select Max(Col2) label Max(Col2)''")
However, it doesn't exclude weekly off days. I have tried to use WORKDAY / workday.intl functions but unable to fetch the correct day. Pls help me.