what is the formula to show the difference between two dates

G

Guest

I need to show the difference between two dates. Someone signed in on Jan 4,
2005 and today's date is the current date. How do i show that and then put it
into a Word document for a mail merge to show each person's enlist date?
 
G

Guest

Hi David,

How about 4/1/05 in A1, =TODAY() in B1, then =B1-A1 in C1. This will by
default return a date, so with C1 selected go the Format menu, click on
cells, ensure the Number tab is selected and click on General and then OK.

For the mail merge, go to google and type 'create mail merge from Excel'
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Help with dates 2
Calculate Holding Period Returns Between Two Customizable Dates 1
Calculating the difference between 2 dates and times 2
Formula for calculating time period between 2 dates 3
I am attempting to find the difference between two dates... 2
Dates in Excel 2007 5
Adjusting a formula to collect data between two dates? 8
Formula to calculate differences between dates?? 8

Top