I have a cell that is linked to another page to pull in the MTD cash
posted per client. I need a formula to put in a column that will show
0.00 and fill in everyday automatically.

Example

Today N8 = 100.00 M10 = 100.00
Tomorrow N8 = 150.00 M11 = 150.00
The next day N8 = 250.00 M12 = 250.00

etc