The formula is correct. Do you happen to have a system where the list
separator is a semicolon (;) instead of a comma (,)?

--
Kind regards,

Niek Otten


"lsmft" wrote in message
...

As fate would have it, I was attempting to do basically the same thing
as JC was asking for. So I stole that formula for my use, but Excel
clanged up a dialog box with a change in it. It replaced a comma with a
*. I have no clue as to why it would do this but it still seems to work
anyway. If I can, I'll copy and paste Excel's dialog box formula, so
here goes:
=DATE(YEAR(TODAY())+IF(TEXT(TODAY()""mmdd"")TEXT( C
3,""mmdd"")*1,0),MONTH(C3),DAY(C3))-TODAY()
For what it is worth;
That "star" falls in place between the last ""mmdd"") and the 1,0).
So far it hasn't seemed to throw a wrench into the job but I guess time
will tell.


--
lsmft
------------------------------------------------------------------------
lsmft's Profile:
http://www.excelforum.com/member.php...o&userid=30678
View this thread: http://www.excelforum.com/showthread...hreadid=516469