+ Reply to Thread
Results 1 to 3 of 3

I want spread a cell value to other cell based on dates

  1. #1
    Registered User
    Join Date
    05-06-2014
    Location
    Muscat,Oman
    MS-Off Ver
    MS office 2013
    Posts
    3

    Unhappy I want spread a cell value to other cell based on dates

    Dear Excel Techies,
    I am a very beginner to excel formulas and data analysis,So excuse me if ask basic questions. I have a task/activity which has a start and finish dates and a amount. I want to distribute the amount to months based on the start and finish date of the activity.

    Kindly see my excel to understand my problem.



    Thanks in advance,
    MuruganS curve practice excel.xlsx

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: I want spread a cell value to other cell based on dates

    Note that your month headers have wrong dates to fill with months reasonably either write Nov 1st, dec 1st then select both cells and drag fill right
    or write first month (say nov 1st in one cell and in a next cell formula =eomonth(previous,0)+1

    Then in F5 write formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    and copy it down/right
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    05-06-2014
    Location
    Muscat,Oman
    MS-Off Ver
    MS office 2013
    Posts
    3

    Re: I want spread a cell value to other cell based on dates

    Dear Kaper,
    Thanks a lot for your help.. You are the master of excel...Great work...

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 8
    Last Post: 05-07-2014, 04:57 AM
  2. Replies: 3
    Last Post: 04-19-2014, 06:10 PM
  3. VBA to manipulate dates based on cell value
    By Buzzter in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2014, 07:07 PM
  4. Spread cell value over multiple cell based on dates
    By royboy9029 in forum Excel General
    Replies: 2
    Last Post: 11-06-2011, 08:29 AM
  5. How to spread out data based on dates and weeks.
    By c991257 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-24-2006, 10:45 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1