IF Function Help
 

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

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

Thanks for the input. All of the Expiration Dates -are- manually
entered. The only non-static date is C1 which changes daily. As today's
date grows closer to a names expiration date, (like within a month of
it), I would like the expiration date to change to "RENEW", just as a
reminder to me when I open the worksheet.

Will your formula still work with these static dates?

Thanks a lot for helping out. I don't know a lot about Excel. Obvious
huh? :rolleyes:


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

capiche,

No you can't have a manually entered date and a formula in a cell at the
same time - entering a date will overwrite the formula.

If you choose a cell adjacent to the expiration date then you can get it to
give the warning or appear blank until that time:

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

for a number of days until the renewal date



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

for a month before the renewl date.


--
HTH

Sandy

Replace@mailinator with @tiscali.co.uk
"capiche" wrote in
message ...

Thanks for the input. All of the Expiration Dates -are- manually
entered. The only non-static date is C1 which changes daily. As today's
date grows closer to a names expiration date, (like within a month of
it), I would like the expiration date to change to "RENEW", just as a
reminder to me when I open the worksheet.

Will your formula still work with these static dates?

Thanks a lot for helping out. I don't know a lot about Excel. Obvious
huh? :rolleyes:


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