Posted to microsoft.public.excel.misc

Redsphynx

external usenet poster

Posts: 22

finding a formula to help with dates.

Hi I am trying to work out a formula to work out the following problem.

If "cell 1" is a later date then "cell 2" then "cell 3" is to be "older"
If "cell 2" is a later date then "cell 1" then "cell 3 is "the number of
days between them"
If "cell 2" has no date then "cell 3" remains blank.

If anyone can help me work this one out, I would greatly appreciate it.

Thanks.

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
Finding MIN value in a column between Two Dates in different columns	ML Srini	Excel Worksheet Functions	3	October 28th 07 03:14 AM
Finding the oldest & newest dates	Bob Smith	Excel Worksheet Functions	3	April 13th 07 02:27 PM
Finding Certain Dates	T_Sr via OfficeKB.com	New Users to Excel	2	February 11th 07 01:09 AM
Help finding dates July thru June	lawdoggy	Excel Worksheet Functions	0	February 7th 06 08:26 PM
Finding data by dates	[email protected]	Excel Worksheet Functions	3	October 4th 05 07:54 AM

All times are GMT +1. The time now is 09:07 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us