ExcelBanter - How can I get yesterdays date in a custom footer &[DATE]-1 does .

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - How can I get yesterdays date in a custom footer &[DATE]-1 does . (https://www.excelbanter.com/charts-charting-excel/13382-how-can-i-get-yesterdays-date-custom-footer-%5Bdate%5D-1-does.html)

chuck

How can I get yesterdays date in a custom footer &[DATE]-1 does .

How can I get yesterdays date in a custom footer &[DATE]-1 does not work

R.VENKATARAMAN

try
=today()-1

chuck wrote in message
...
How can I get yesterdays date in a custom footer &[DATE]-1 does not
work

All times are GMT +1. The time now is 03:46 PM.