+ Reply to Thread
Results 1 to 2 of 2

Project Management Schedule

  1. #1
    Registered User
    Join Date

    Project Management Schedule

    Good afternoon,
    I downloaded a MS template for project management and it is laid out like this:
    Cell D Cell E Numbered Days Across the Top
    Days Start End
    52 16-Nov 15-Nov
    with this behind 15-nov (=IF(AND(D46,E46),E46+D46,"")

    now when i enter in the number of days, the formula automatically enters the end date and fills the cells to the right for the number of days with blue.

    Now i would like to modify it for 'weeks' rather than 'days', so i modified the formula to (=IF(AND(D46,E46),E46+(D46*7),""), however it no longer fills the cells to the right with blue.

    Did i modify the formula correctly?
    any suggestions?

  2. #2
    Registered User
    Join Date
    Check the cells to the right for conditional formatting. By altering the formula you may have to change the values of the conditional format to adjust.

    Good Luck.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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


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