Automate data entry on specific date every month

Question

I have designed a table for my monthly income and expense entry. There are certain entry like home loan EMI needs to enter on specific date i.e. 5th of every month.

now i wanted to make this entry on auto mode every month in my table.

i tried few of formula but auto posting is not happening with any of the formula.

need help.

Answer 1

Hi @Vishal Jhaveri

If an entry is generated on specific days of each month, it's best to use VBA code.

But you can try to generate this entry every table, using a formula to judge: if it is on specific days of each month, the value is XXXX, otherwise the value is 0.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment". Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

---