Excel Dates (Months)

[JrClown]

Ok Fellas I have a question.
On an excel sheet, cel A1 I have the following date 10/30/00
I would like cel B1 to display a date three months later 1/30/01
I'm stuck. X-)
Thanks in advance.

 

[culshaja]

Use the function DateAdd, and use the "m" switch.

Try

DateAdd("m", 3, A1)

. My Excel as atrociuos so putting A1 where the date to be added to should go might not work, but you get the idea.

james James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[JrClown]

Perhaps I shoudl've been more specific on my question.

Cell a1 will always be an empty cell untill user enters a date.
Cell b1 will always reflect a date three months later from entered date on cell a1.
I don't know what date will be entered on cell a1.

 

[culshaja]

Excel knows that you are referring to what is contained within cell A1. If you put

=DateAdd("m", 3, A1)

then when you change cell A1, cell B1 will change to reflect this.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305

 

[JrClown]

I'm sorry James, but this =DateAdd("m", 3, A1) is not working. I keep getting #name? on B1. What am I doing wrong....

 

[dsi]

Make sure that the cell B1 is formatted as a DATE.

 

[JrClown]

Thank you all for your help.
I found the answer I was looking for.
Here's the example:

Cell A1 is blank, when user enters a date into A1
Cell B1 will show a date 3 months later
here's the code that goes into cell B1:

=EDATE(A1,3)
This will increase the CELL A1 input by 3 months
Thank you all

 

[Dreamboat]

Cool, Jr. If you're using similar functions, you could always do something like:

=if(isblank(a1),"",DateAdd("m", 3, A1))


techsupportgirl@home.com

http://www.wedomanuals.com

 

[JrClown]

Yeah Thanks man, I format lost of paper forms into excel for company use. Thanks for your help tho B-)