Help with a formula

Question

Could someone help with a formula please?

I need to add a blank if nothing is entered in the date closed column.

Current Formula adds Yes when no date has been entered.

=IF(P2<M2,"Yes",IF(P2>M2,"No",""))

Answer 1

Hi LNJJNS,

I'm writing a follow up this case, and I haven’t received any information from you, may I know have you checked above reply? Feel free to post back if you need further assistance.

Have a good day and stay safe 😊

Sincerely,

Waqas Muhammad

Answer 2

Hi,

So sorry, I thought I'd replied.

This answer worked perfectly! Thank you so much 👍

Answer 3

Hi LNJJNS,

Thanks for your valuable feedback and sharing updates with us and I really appreciate your effort and your precious time doing. 

And I appreciate your kind words.

No problem at all! Based on your requirements, we can create a formula for Column N (Deadline Met) that checks if the date in Column P (Date Closed) meets the deadline in Column M (Deadline Date). If no date is entered in Column P, it will leave both Column P and Column N blank.

Here’s the formula you can use in Column N:

=IF(P2="", "", IF(P2<=M2, "Yes", "No"))

In this case, if you think my provided idea is helpful and you can understand my explanation and correct direction on this whole scenario, could you please use the feedback tool to send us feedback? (photo below).

Your feedback really means a lot to the dedicated members of our community.

If there are any issues with Office apps in the future, feel free to post to this community again.

We will be there to help you.

Have a great day and stay safe 😊

Sincerely

Waqas Muhammad

Answer 4

Hi Wasqas,

Many thanks for your reply and good day to you to.

I'm sorry, formulas are all new to me.

Column P = date closed

Column M = Deadline date

I'd like a formula for -

Does the date closed meet the deadline date, "Yes" or "No", if no date closed is entered, leave both Column P (date closed) and Column N (Deadline Met) blank

Answer 5

Dear respected LNJJNS,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, may I know does the M2 is a date closed column? if yes then

=IF(M2="", "", IF(P2<M2, "Yes", IF(P2>M2, "No", "")))

If there is any misunderstanding, I apologize and please feel free to post back to us with more detailed information for better understanding and guiding you further.

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

I'm sorry and I apologize for that.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely,

Waqas Muhammad