Date Manipulation, I need Help...

[doms123]

Hi, I'm using Excel 2007 and having problem with date, plese help me...

I have 3 rows for the Month, Date, Year respectively and i want it to be converted in a single cell so that i can manipulate and compared it with the today date and add days, week or month on the next cell. For example


Month Date Year
March 11 2011 >>>> 03/11/2011

so that in the next cell i can have a formula like this and in the next cell i can have a formula something like this D1 + 1month
and then the result is this >>> 04/11/2011

PS. Please give me detailed answer, I really appreciate it...

Please Help me!!!
Thank you in advance....

 

[doms123]

But how to add 1 month or 2 weeks???

 

[VoG]

To add a month to the date in D1

=DATE(YEAR(D1),MONTH(D1)+1,DAY(D1))

To add 2 weeks

=D1+14

 

[doms123]

Sir a big thanks again... you really a big help!!!

 

[doms123]

My last question is how to do it in vice versa???

like 4/8/2011 in a single cell then it will be this distributed in 3 single cells like

month date year
April 9 2011


Thanks again...

 

[VoG]

Month =TEXT(D1,"mmmm")

Day =DAY(D1)

Year =YEAR(D1)

 

[doms123]

Thanks man....