If cell text equals, then add days to a date in another cell

**raisin3** · 04-19-2019, 07:36 PM

Excel Formula.JPG

I'd would love some help with writing this formula.

If F3 equals ANN then H3 equals G3 +364 days, if F3 does not equal ANN then leave blank.

Thanks in advance for any help you are able to provide

**jeffreybrown** · 04-19-2019, 07:41 PM

Hello & Welcome to the Forum,

Try >> =IF(F3="ANN",G3+364,"")

**raisin3** · 04-19-2019, 08:04 PM

Thanks! I thought I tried that, but realized now that I missed the , after "ANN".

Appreciate the help

**jeffreybrown** · 04-19-2019, 08:28 PM

Glad it's all sorted now. You are welcome and thanks for the feedback.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

If cell text equals, then add days to a date in another cell

LinkBack

Thread Tools

Rate This Thread

Display

If cell text equals, then add days to a date in another cell

Re: If cell text equals, then add days to a date in another cell

Re: If cell text equals, then add days to a date in another cell

Re: If cell text equals, then add days to a date in another cell

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] If a cell in a column equals today's date return the value of another cell adjacent to it

[SOLVED] When one cell equals value of another cell, then third cell displays text of fourth cell?

If cell equals a text then insert a number, (text cell comes from a data validation)

[SOLVED] Macro to add so many days if a cell equals todays date

Count cells containing unique text in cell A if cell B equals i.e. 1

Text entered into one cell equals a number in a different cell.

If text in cell equals text in another cell, highlight both same color.

Bookmarks

Bookmarks

Posting Permissions