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

Flourgrader

New Member
Joined
Feb 26, 2019
Messages
15
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

Well-known Member
Joined
Mar 5, 2018
Messages
991
Office Version
  1. 2016
Platform
  1. Windows
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.
 

Some videos you may like

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.

Flourgrader

New Member
Joined
Feb 26, 2019
Messages
15
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........
 

Watch MrExcel Video

Forum statistics

Threads
1,112,816
Messages
5,542,660
Members
410,567
Latest member
SCraig123
Top