How to auto insert money on a set calendar date in my spreadsheet ?

[Flourgrader]

Hi Everyone,

I have 2 questions that I hope someone can help me with?

I have just retired from work, and my pension is been paid

every 28 days.

I would like to be able to have Excel auto insert this amount in (money xxx.00) into my spreadsheet.

I also have another small payment made on the first day of every month, I would like have Excel auto insert this figure too.

Could you please keep the answers simple as I am an inexperienced user of Excel, but trying to learn!

Thank You for your help.

 

[Toadstool]

Hi Flourgrader,

Format all the date cells (D1 to O1) in your preferred date format and type 1/1/2020 into D1.
If that still gives errors then I'm not quite sure what's happening, unless you followed Logit's link to turn off automatic calculation? In which case you can press F9 to force a calculation or reset to automatic.

If you expect to ask more questions on this forum then you should probably install XL2BB. You'll see a link at the top of your reply banner.

 

[Logit]

You are welcome.

 

[Flourgrader]

Your formulas work perfectly Toadstool!
Deleted everything my end, on on third go worked just fine!
Very bizarre ??
I changed nothing!
Thanks again for your assistance........

 

[Toadstool]

You're welcome!