I've got a spreadsheet that lists, among other things, beginning balances, amounts to be paid, and ending balances (Beginning - paid = ending). Is there any way to make this formula occur ONLY, and automatically, on the 1st of every month without any user intervention? If I was to leave this file closed for 2 months and then open it, what would it take for it to realize 2 months have passed and process the amount paid twice?
Scott
Scott