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

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

On Apr 8, 1:50*pm, Dave Peterson wrote:
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- Hide quoted text -

- Show quoted text -

I do want the result in a single cell and what you sent works...
However, when I put your formula in the B1 cell
I am getting it to show...
01/29/1968 - 02/02/1968

What I need is the year to be current ...
01/29/2009 - 02/02/2009

Any and all help greatly appreciated

Sorry, I missed that:

=text(date(year(today()),month(a1),day(a1)-2),"mm/dd/yyyy") & " - " &
text(date(year(today()),month(a1),day(a1)+2),"mm/dd/yyyy")


Sunflower wrote:

On Apr 8, 1:50 pm, Dave Peterson wrote:
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- Hide quoted text -

- Show quoted text -

I do want the result in a single cell and what you sent works...
However, when I put your formula in the B1 cell
I am getting it to show...
01/29/1968 - 02/02/1968

What I need is the year to be current ...
01/29/2009 - 02/02/2009

Any and all help greatly appreciated

--

Dave Peterson

On Apr 8, 3:50*pm, Dave Peterson wrote:
Sorry, I missed that:

=text(date(year(today()),month(a1),day(a1)-2),"mm/dd/yyyy") & " - " &
*text(date(year(today()),month(a1),day(a1)+2),"mm/dd/yyyy")





Sunflower wrote:

On Apr 8, 1:50 pm, Dave Peterson wrote:
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- Hide quoted text -

- Show quoted text -

I do want the result in a single cell and what you sent works...
However, when I put your formula in the B1 cell
I am getting it to show...
01/29/1968 - 02/02/1968

What I need is the year to be current ...
01/29/2009 - 02/02/2009

Any and all help greatly appreciated

--

Dave Peterson- Hide quoted text -

- Show quoted text -

BEAUTIFUL!!! Works like a charm!! Thank you so much