Posted to microsoft.public.excel.newusers

ShamsulZ

external usenet poster

Posts: 23

Date matter

Say cell A1 the date is '01/09/2006' and i want to know how many days there
are to 30/09/2006. i try '=30/09/2006-A1' but it not working. pls help with
the correct formula. thanks friends

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
insert date	Larry	Excel Worksheet Functions	28	July 15th 06 02:41 AM
Date format issue	CindyLF1	New Users to Excel	3	June 12th 06 06:18 PM
Another Date issue.	TimM	Excel Worksheet Functions	1	November 17th 05 01:58 AM
NETWORKDAYS - Multiple Date Selection	Annabelle	Excel Discussion (Misc queries)	3	October 4th 05 07:04 PM
Date issue between Windows and Macintosh version	dlg1967	Excel Discussion (Misc queries)	4	January 19th 05 03:51 PM

All times are GMT +1. The time now is 08:22 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us