Posted to microsoft.public.excel.worksheet.functions

Stefi

external usenet poster

Posts: 2,646

date formulas

And format reult cell as General!
Stefi

€žrwpatter1€ ezt Ã*rta:

I have a simple question. In one column I have employee start dates. I need
the column next to it to count down the days to one year employed.

i should see today:
1 column next column
03/01/09 339

tommorow it would show:

1 column next column
03/01/09 338
--
William

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Date Formulas	JF[_2_]	Excel Worksheet Functions	1	November 6th 07 11:29 PM
Date Formulas	Alyssa	Excel Discussion (Misc queries)	5	July 20th 07 06:12 PM
date formulas	Karl	Excel Discussion (Misc queries)	1	March 31st 07 05:30 AM
date formulas	sunderland27	Excel Discussion (Misc queries)	2	April 24th 06 08:59 PM
Using formulas to determine date in one cell based on date in anot	Gary	Excel Worksheet Functions	2	November 22nd 04 08:11 AM

All times are GMT +1. The time now is 12:44 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us