• 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.

If cell = specific text (dropdown list) then add days to a date in another cell

HealthStaff

New Member
Helloo, My name is Craig,
I am a bit lost with this one but I would like to..
If text in column E = certain texts(dropdown List) then add certain numbers of days to date in column J display due date in column K
Many Thanks for any assistance.
I've attached a copy of workbook for reference.

Kind Regards
Craig
 

Attachments

  • Copy of FOI checklist.xlsm
    40.2 KB · Views: 2
HealthStaff
I was lost too ...
until I took some spaces away from Your sheetnames as well as from list.
You could continue from this ...
 

Attachments

  • Copy of FOI checklist.xlsm
    43.4 KB · Views: 2
Back
Top