In a single cell?

=text(a1-2,"mm/dd/yyyy") & " - " & text(a1+2,"mm/dd/yyyy")

Where A1 contains the date.



Sunflower wrote:

I have column of birthdates and need to have a date range showing 2
days before and after the Month and day (in current year) of
birthdate.

For example

Birthdate:
01/31/1968

Result:
01/29/2009 - 02/02/2009

Is this possible?

Any and all help greatly appreciated

--

Dave Peterson