Two dates selections

[rash_611]

Hi,

On the activate of a sheet i need select today and yesterday date in triggers. kindly any one help me.

Regards,

Grace

[kaushiknsolanki · Accepted solution]

Hi,

Try this.

     ='(' & Today() &'|' & Date(Today()-1)&')'

Regards,

Kaushik Solanki

[#3]

just go through below link i hope it will helps you

Date Range Selection

if u need more clarification on this please type date range function in youtube  you get a soluton

[rash_611]

Thanks a lot