Add 2 days before and after birthdate
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
|