Results 1 to 9 of 9

Changing dates in excel based project plan

Threaded View

  1. #1
    Registered User
    Join Date
    09-04-2014
    Location
    england
    MS-Off Ver
    2010
    Posts
    4

    Post Changing dates in excel based project plan

    Hello everyone

    I am a complete newbie so I apologise for basic phrasing. So, here's my problem which I hope you can help me solve quicker than having to do this manually (FYI - I have just a standard excel package, no extra fancy functions referred to in other posts).

    Last year I created a project plan in excel for a specific project (yes, I know this is not the best software to do this in, but users of the project plan were not keen on anything 'proper')... I am now looking to replicate this project plan for a new project, same tasks deliverables etc, but I need to change the start and end dates and would rather not do that manually for each cell. Is there a way I can do this quickly in excel via a formula. I simply need to have dates for this new project 12 months later. My dates are entered in a simple date format, nothing fancy.

    Many thanks for all your help!
    Last edited by MATEJASIMIC; 09-04-2014 at 06:07 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Dynamically open MS project plan and get task detail into MS Excel 2007
    By alonatart in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2014, 03:48 PM
  2. Does anyone have an Excel template for a project plan?
    By Kynthia Melissa in forum Excel General
    Replies: 1
    Last Post: 07-17-2012, 04:17 PM
  3. using a variable from excel, open up a project plan and filter
    By croukamp in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-01-2009, 09:55 PM
  4. Project Plan Creation in Excel (Gantt Charts)
    By leeb1977 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-19-2008, 05:58 AM
  5. [SOLVED] How to Copy a project plan to Excel through macro or batch file?
    By Project to Excel in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-04-2006, 01:25 AM

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