excel - due date

[Leonard Harrietha]

I am creating a list of companies I send resumes to.
example:columns : company, contact, sent via, date sent and resend date.

My question: when I enter the "date sent", is there a way for excel to show me in the in the "resend" column the date 6 months from the time entered(in the date sent column), when its time to resend my resumes.


I hope I explained myself right.

Thank you
Leonard (leonardharrietha@yahoo.ca)

 

[Atom]

try =d1+180 and format it as a date

 

[NBVC]

A quick and dirty way is to approximate:

=A1+(6*30) or =A1+180

 

[barry houdini]

If you have Analysis ToolPak installed use

=EDATE(A1,6)

 

[Datsmart]

Without Analysis ToolPak you can use this:

=DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))

Give you 6 months from the date in Cell A1

 

[gheyman]

Use the EOMONTH FORMULA

=EOMONTH(A1,6) this brings you to the last day of the month "6" months away.

 

[gheyman]

123

 

[Atom]

Datsmart, very sneaky! I like your approach!

 

[PaddyD]

Post from the OP saying 'thanks' here:

http://www.mrexcel.com/board2/viewtopic.php?t=180196&highlight=