VBA need to input yesterdays date in a field in IE11

[Johnnyv015]

Hello Gurus,

I am trying to input yesterdays date in a field in IE. My code currently gets me to the page, and I need to have it always enter the previous date in the cell to generate the report I will be pulling to Excel.

Any ideas on how I can do this? I have already tried

            HTMLDoc.all.ex1_inputE1.Value = "=TODAY()-1"
            HTMLDoc.all.ex2_inputE1.Value = "=TODAY()-1"

But this is not working.

Thanks,
John