View Single Post
  #3   Report Post  
Mangesh Yadav
 
Posts: n/a
Default

In cell D35, enter the formula:
=DATE(D3,1,1)+59
and format it as dd mmm

Mangesh



"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?