converting months/days to today's date

sandy

New Member
Joined
Feb 25, 2002
Messages
24
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 :cool:
 

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
Joined
Feb 25, 2002
Messages
24
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
Joined
Feb 25, 2002
Messages
24
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
Joined
Mar 10, 2004
Messages
1,174
try:
Code:
=DATE(YEAR(A1),MONTH(A1)-LEFT(B1,FIND("/",B1)-1),DAY(A1)-RIGHT(B1,2))
 

sandy

New Member
Joined
Feb 25, 2002
Messages
24
THANK YOU!!!

Fergus - THANK YOU SO MUCH! This worked perfectly!

Grateful...
-Sandy :cool:
 

Forum statistics

Threads
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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Top