Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula to show the difference between two dates
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula to show the difference between two dates
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' -- Hope this helps, MarkN "David" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to show the formula and the answer? | Excel Discussion (Misc queries) | |||
How do I set a formula to show a difference in sets of data enter | Excel Worksheet Functions | |||
How to show the formula of another cell | Excel Worksheet Functions | |||
I need the difference between two dates expressed as 4 years 3 mo. | Excel Discussion (Misc queries) | |||
how to show formula in formula bar | New Users to Excel |