How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, BS Degree in Engineering.
Category: General
Satisfied Customers: 9666
Experience:  Math, science and 25 years experience in computer programming
Type Your Question Here...
John D is online now
A new question is answered every 9 seconds

On an Excel spreadsheet I need to automatically return a value

Resolved Question:

On an Excel spreadsheet I need to automatically return a value based on a couple of conditions. My formula does not work.

If cell J3 has a date entered and
Cell C3 contains the letter P
Cell D3 will return a value of the date in J3 plus 30 days.

If conditions are not met cell D3 remains blank.

My formula =IF(AND(I3>0,C3="P"), I3+30,"")
Submitted: 4 years ago.
Category: General
Expert:  John D replied 4 years ago.

Hi again,


There is no ISDATE function in the standard excel functions but you can check if the value is greater than say year 2000.


=IF(AND(I3>36525,C3="P"), I3+30,"")


(note you said J3 but your formula has I3)


Hope this is ok. Let me know if you have any questions


John D and 40 other General Specialists are ready to help you