conversion to EDATE

[ss]

Having got edate working now can the formula below be converted, I have
tried a few options but obviously making errors.
The >180 represents 6 months, I am looking to deduct 6 months in
preference to 180 days.

=IF(D5-D11>180,"","RENEW")

 

[Stan Brown]

Having got edate working now can the formula below be converted, I have
tried a few options but obviously making errors.
The >180 represents 6 months, I am looking to deduct 6 months in
preference to 180 days.

=IF(D5-D11>180,"","RENEW")

=IF(D5 > DATE(YEAR(D11),MONTH(D11)+6,DAY(D11)), "", "RENEW")

A nice feature of DATE() is that you can add or subtract days or
months within the function and it makes the right conversion.

 

[joeu2004]

Having got edate working now can the formula below be
converted, I have tried a few options but obviously
making errors. The >180 represents 6 months, I am
looking to deduct 6 months in preference to 180 days.
=IF(D5-D11>180,"","RENEW")

=IF(D5>EDATE(D11,6),"","RENEW")

 

[ss]

Having got edate working now can the formula below be converted, I have
tried a few options but obviously making errors.
The >180 represents 6 months, I am looking to deduct 6 months in
preference to 180 days.

=IF(D5-D11>180,"","RENEW")

Thanks I have extended this to:-
=IF(D5>EDATE(D13,6),"OK","RENEW")
And this works good, however I now want a blank cell if nothing is
entered in the cell, it currently displays either OK or renew.
I tried =IF(D5>EDATE(D13,6),"OK","RENEW","",)
But this doesnt give me a blank cell.
To clarify, I need 3 options:-
either `OK`
Or `Renew`
Or a blank cell
Its the blank cell I cant fathom.

 

[joeu2004]

I have extended this to:-
=IF(D5>EDATE(D13,6),"OK","RENEW")
And this works good, however I now want a blank cell if
nothing is entered in the cell, it currently displays
either OK or renew.

What is "the" cell: D5 or D13 or both?

This should cover all bases, albeit possibly more complicated than you
require.

=IF(OR(D5="",D13=""),"",IF(D5>EDATE(D13,6),"OK","RENEW"))

 

[ss]

What is "the" cell: D5 or D13 or both?

This should cover all bases, albeit possibly more complicated than you
require.

=IF(OR(D5="",D13=""),"",IF(D5>EDATE(D13,6),"OK","RENEW"))

That works perfectly, thank you.

D5 is expiry date for passport
D13 Is date leaving the visiting country
And the cell the formula is in states either OK, Renew or remains blank
if no information in cell D13