Posted to microsoft.public.excel.newusers

pcor

Posts: n/a

Formating dates

I have dates and times in 2 cells(a1 and b1). How do I format an other
cell(c1) to tell me hiow many days there is between cells (a1 and B1).
Thanks
Ian

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
conditional formating dates	Brockjr38	Excel Worksheet Functions	1	February 13th 06 11:04 PM
Install dates formating using conditional formating?	Jerry Eggleston	Excel Discussion (Misc queries)	2	November 9th 05 05:49 PM
conditional formating: dates	steely	Excel Worksheet Functions	1	October 20th 05 11:20 AM
conditional formating using cells containg dates	Roy	Excel Discussion (Misc queries)	2	May 24th 05 09:52 PM
Formating Dates for production schedule	dpl7579	Excel Discussion (Misc queries)	1	January 11th 05 08:43 PM

All times are GMT +1. The time now is 03:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us