Question;
My friend had a situation that he want create a sheet that every forth month on the same date of billing the customer needs to be remained for their premium payment. He want a function to use in his formula since their are 300 customer he need to send advice on next billing.
My Solution is;
Step 1 : Customer are need to be reminded for their premium payment on quarterly basis. In a column put the billing date.
Step 2 : Create a column to find the date on which the reminder has to be send.
Step 3 : If D1 has the billing date; the function/formula at E1 is;
=DATE(YEAR(D1),MONTH(D1)+3,DAY(D1))
Step 4: Copy the formula for all the rows which will give you the next billing date.
My friend had a situation that he want create a sheet that every forth month on the same date of billing the customer needs to be remained for their premium payment. He want a function to use in his formula since their are 300 customer he need to send advice on next billing.
My Solution is;
Step 1 : Customer are need to be reminded for their premium payment on quarterly basis. In a column put the billing date.
Step 2 : Create a column to find the date on which the reminder has to be send.
Step 3 : If D1 has the billing date; the function/formula at E1 is;
=DATE(YEAR(D1),MONTH(D1)+3,DAY(D1))
Step 4: Copy the formula for all the rows which will give you the next billing date.
No comments:
Post a Comment