Dates changed to next month when I indicate I paid a bill.

[JOHNO]

I use a excel for bills at home, when I pay a bill I would like the next bill date updated automatically and balances changed. Some balances are on credit cards and vary with % - some balances are just subtraction.
Thanks in Advance.
JohnO

 

[plettieri]

Re: Dates changed to next month when I indicate I paid a bil

Hi:
It might be helpful to show the format you would like and a short sample set of your data..

plettieri

 

[JOHNO]

Re: Dates changed to next month when I indicate I paid a bil

All Bills 1-15-04.xls
	A	B	C	D	E	F	G	H	I	J	K	L
1	Type	AlphasortBills	Due	Due	AllowDays	Sendon	MinPayt	OldBalance	LastPayt	NewBalance	PaidLastOn	Current
2	MM	AllstateInsuranceCar	01/07/04	07	10	27	159.93	622.22	159.93	462.29	01/12/04	FEB
3	MM	AllstateInsururanceHome	01/07/04	07	10	27	44.75	453.75	44.75	371.25	01/12/04	FEB
4	MM	AmerenCIPS	01/13/04	13	10	03	57.99	253.99	253.99	173.00	01/12/04	FEB
Bills

 

[JOHNO]

Re: Dates changed to next month when I indicate I paid a bil

All Bills 1-15-04.xls
	A	B	C	D	E	F	G	H	I	J	K	L
1	Type	AlphasortBills	Due	Due	AllowDays	Sendon	MinPayt	OldBalance	LastPayt	NewBalance	PaidLastOn	Current
2	MM	AllstateInsuranceCar	01/07/04	07	10	27	159.93	622.22	159.93	462.29	01/12/04	FEB
3	MM	AllstateInsururanceHome	01/07/04	07	10	27	44.75	453.75	44.75	371.25	01/12/04	FEB
4	MM	AmerenCIPS	01/13/04	13	10	03	57.99	253.99	253.99	173.00	01/12/04	FEB
Bills

 

[plettieri]

Re: Dates changed to next month when I indicate I paid a bil

Hi JohnO

and welcome again...

now that you have your sample posted up...just explain what you would like to see as an expected result with the data you posted.

plettieri

 

[JOHNO]

Re: Dates changed to next month when I indicate I paid a bil

I want my due dates for my bills & my balances for my credit cards & other bills to update automatically when I indicate I have made a payment.