How do you subtract 20 days from a date format that is in YYYYMMDD format.
Sometimes it works if I do (date - 20) but if the date is less than 20 days it does not calculate correctly?
I need to have the data in column G (=f2-20)
As you can see it errors out to "20160097" in the example.