IF Function Help

[capiche]

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 "date
registered" and "expiration dates" beside each domain name. I also hav
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 t
"RENEW", IF it doesn't equal that date, I just want it to stay th
same.

Could anyone tell me how to do this?

Hope this makes sense.
Thanks,
Scot

 

[Sandy Mann]

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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk

 

[capiche]

Thanks for the input. All of the Expiration Dates -are- manuall
entered. The only non-static date is C1 which changes daily. As today'
date grows closer to a names expiration date, (like within a month o
it), I would like the expiration date to change to "RENEW", just as
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. Obviou
huh? :rolleyes

 

[Sandy Mann]

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+20>C1,"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
(e-mail address removed)
Replace@mailinator with @tiscali.co.uk