# converting months/days to today's date

#### sandy

##### New Member
This may be an easy one for you folks, and unfortunately, I am still not very good with formulas. I am requesting assistance here from those experts who may be able to help. I don't have time to see if this has already been addressed... sorry! I am in a real bind to figure this out as quickly as possible.

I have a huge list of dates (department seniority dates) that look like this MONTHS/DAYS (375/06) = (375 months/06 days). I am needing to change this over to a date (from the date: 10/16/06). I know there has to be a way to convert this through a formula. Anyone care to take a stab at this?

If anyone can help me with this, I would be very appreciative!

-Sandy

### Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

#### sandy

##### New Member
On the title of my post, I said today's date. Actually, it should show yesterday's date: 10/16/06. I'm very sorry for the confusion!

#### sandy

##### New Member
Clarification

Should I use the IF statement for this?

Cell A1 10/16/06
Cell B1 375/06 (which means 375 months & 6 days)

I am looking for a formula on cell C1 -->> 03/14/1975 (or something close to this) based on 10/16/06.

Thanks for looking at this and your help!

-Sandy

#### Fergus

##### Well-known Member
try:
Code:
``=DATE(YEAR(A1),MONTH(A1)-LEFT(B1,FIND("/",B1)-1),DAY(A1)-RIGHT(B1,2))``

#### sandy

##### New Member
THANK YOU!!!

Fergus - THANK YOU SO MUCH! This worked perfectly!

Grateful...
-Sandy

Replies
17
Views
1K
Replies
5
Views
203
Replies
3
Views
314
Replies
5
Views
589
Replies
5
Views
105

1,136,600
Messages
5,676,727
Members
419,647
Latest member
usas12gthr

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back