Forum Discussion
need help in using IF formula and EDATE at same time
Hi in this excel sheet I want to put formula if MFD+Expiry is greaten than EDATE(B8,24) then EDATE(B8, 24)) if its less then Reference cell H8
Hi, what exactly do you mean by MFD + Expiry? What do you want to sum? Logic behind? Are you looking for the condition to be met if both dates are greater than?
This might put you into the right direction (only taking into account the expiry date):
=IF(H8>EDATE(B8,24),EDATE(B8,24),H8)
3 Replies
Hi, what exactly do you mean by MFD + Expiry? What do you want to sum? Logic behind? Are you looking for the condition to be met if both dates are greater than?
This might put you into the right direction (only taking into account the expiry date):
=IF(H8>EDATE(B8,24),EDATE(B8,24),H8)
- Thanks
MFD+EXP (EDATE(G8,H8) if its less than EDATE(B8,24) then i want reference cell H8
If its greater then i want "NA" It worked now with this =IF(H8<EDATE(B8,24),H8,"NA")
