Project Management Schedule

  • Thread starter Thread starter JPriest
  • Start date Start date
J

JPriest

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?
 
Check the cells to the right for conditional formatting. By alterin
the formula you may have to change the values of the conditional forma
to adjust.

Good Luck
 
You must log in or register to reply here.

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

Autofill cell reference forumula not working 4
Counting X's 4
tie info to names across spreadsheets 1
Any ideas for this formula??? 3
GETPIVOTDATA problem 4
Number value based on date function 2
Which Formula???? 1
Calculate End Date Using Start Date and No. of Days excluding specific days. 0

Back
Top