• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Formulas in lists

M

marine

New Member
Hello, I am making a workbook that has a list selection in column F, i want to be able to select an item and it takes the date from column D and subtracts a set number of days and the result shows in column G.
 

Attachments

  • Excel Q.xlsx
    10.7 KB · Views: 3
Hi:

Is this what you are looking for?
Formula on colored cells

Thanks
 

Attachments

  • Excel Q.xlsx
    11 KB · Views: 4
Hello, i am trying to modify the DUE DATE based on what selection you make from the list, each award has its days due prior. The DUE DATE will be however many days the award needs subtracted from the Departure Date (DEP DATE).
 
Hi:

I did not understand what you meant to say , the index formula will bring the day's prior based on the selection you make and will subtract from the Dep Date. If this is not what you are looking for can you give the expected result manually on the due date column.

Thanks
 
Hi:

I am not sure what you have tried, the file I have attached is giving you a date value on column due date. Can you attach the file you are working on, without seeing what you have done I cannot comment on it. It would be better if you could manually give me the expected results for each selection, if the dep date is today.

Thanks
 
Im sorry, i didn't realize you put a formula in the file, yes that is exactly what i was looking for thank you.
 
You must log in or register to reply here.
Back
Top