Code for auto filling in Excel based on number of months, & start date

D

Diane Sulton

I have an excel spreadsheet with
Invoice data across in rows.
These are subscriptions with start and end dates. I want to
automatically fill in the appropriate column [Jan, Feb, March, April,
May ....etc] the total amount of the invoice divided by the number of
months. If I have $100 for the invoice amount, and a subscription
period of 10 mos, and the subscription starts in Jan. I want to search
the row, look for the start date, the amount of the invoice/number of
months of subscriptions, and place this amount in the appropriate
columns(Jan, Feb, March...etc).

Thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Counting Specific Number of Days across Multiple Months 7
how to sum values of an unkown number of cells 3
duplicate row based on calculated number of months 2
Set Up Calendar To Account For Leap Years 2
Loop and AutoFill 1
Pls Help on from date tranfer amount to month 3
Excel How to calculate in excel number of open actions that expired (older then today) 0
Compare shorter date range against longer date range 2

Top