Assuming that the "Expiration Date" is not manually entered but calculated
then with the "Date Registered" in A1, for a number of days try:

=IF(A1+20<C1,"Renew",A1+20)

For a number of Months try:

=IF(DATE(YEAR(A1),MONTH(A1)+3,DAY(A1))<C1,"Renew", DATE(YEAR(A1),MONTH(A1)+3,DAY(A1)))

Although note that three months on to August 31st will be December 1st not
30th November. If you want the last day in the month then post back

--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk

"capiche" wrote in
message ...

Hi Guys,

I'm a NEWB. Nice Forum.

I'm making a worksheet and I'm having problems with the "IF" function.
I'll explain what I'm doing and if you wouldn't care, please help. :)

I'm just making a worksheet of my domain portfolio. I have the "dates
registered" and "expiration dates" beside each domain name. I also have
the "Today" function running in cell C1 on top of the worksheet.
What I want to do, is create an if string for each "expiration date"
saying, IF C1 equals a certain date, then change the expiration date to
"RENEW", IF it doesn't equal that date, I just want it to stay the
same.

Could anyone tell me how to do this?

Hope this makes sense.
Thanks,
Scott


--
capiche
------------------------------------------------------------------------
capiche's Profile:
http://www.excelforum.com/member.php...o&userid=26697
View this thread: http://www.excelforum.com/showthread...hreadid=399633