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....

 

[Giordano Bruno]

=Date(C1,A1,B1)

 

[Robert Mika]

If your data are in cels
A1,B1,C1 use
=DATE(C1,A1,B1)

To add a month just put 1 in cell let say A3
and then use:

=DATE(C1,A1+A3,B1)

 

[doms123]

thanks man for the quick help but i have a problem in month. My month is in text and not in numerical value, how do i convert it....

 

[Robert Mika]

It should not matter but try:
=DATE(C1,VALUE(A1),B1)

 

[VoG]

Try

=DATEVALUE(B1&"-"&A1&"-"&C1)

format as Date.

 

[doms123]

it does not working man... but thanks for the effort.

 

[Robert Mika]

Have you tried VoG formula?
If still does not work- what error are you getting?

 

[VoG]

If you use US dates (MDY) then my formula should be

=DATEVALUE(A1&"-"&B1&"-"&C1)

 

[doms123]

BIG THANKS.. Sir VoG it works!!!