Atif

Posts: n/a

Difference of date

1. I have 2 columns : 1. start date 2. end date, how can I formulate in the
3rd column to show the difference in days?

2. I have dates in custom format i.e dd mmm yy but still on the formula bar
it shows as d/m/yyyy. When I type in the date 2/1/05 it shows as 01 Feb 05
whereas it should show 02 Jan 05. What could be wrong here?

TIA

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
Date updates from worksheet to chart & changes date to a date series! Help!!	Jayjg	Charts and Charting in Excel	2	January 22nd 05 03:00 PM
Date issue between Windows and Macintosh version	dlg1967	Excel Discussion (Misc queries)	4	January 19th 05 03:51 PM
Calculating Date difference in 2 ways	Hari	Excel Discussion (Misc queries)	5	January 15th 05 10:25 PM
Date formula	Robyn Bellanger	Excel Discussion (Misc queries)	2	December 16th 04 12:41 AM
Addition to Turn cell red if today is greater or equal to date in cell	Rich	New Users to Excel	2	December 9th 04 02:06 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us