No need for 2 formulas

=DATE(D3,2,29)

custom format as d mmm

--
Regards,

Peo Sjoblom

(No private emails please)


"paddymack" wrote in message
...
I am creating an appointment book and want to accomodate the extra day
every
leap year. If D3=2006 than D35=1 March but if D3=2008 it must be 29 Feb.
I
need two formulars in one cell to accmodate the variation in D3. Can
anybody
help?