Hi Guys,

I am trying to get date in col. Q from col.M. Logic is if my date in col. J is less than date mentioned on cell Y1, then it should return the value on col. J else return "0".

It should be very simple formula but if you see in col. J date format is different, so the question is:-" How to simplify date to show only "DD-MM-YYYY" in col. J and then applied the if formula in Col. Q'

I tried several methods but not able to get the desired results. Thanks

I am trying to get date in col. Q from col.M. Logic is if my date in col. J is less than date mentioned on cell Y1, then it should return the value on col. J else return "0".

It should be very simple formula but if you see in col. J date format is different, so the question is:-" How to simplify date to show only "DD-MM-YYYY" in col. J and then applied the if formula in Col. Q'

I tried several methods but not able to get the desired results. Thanks