Posted to microsoft.public.excel.misc

TUNGANA KURMA RAJU

Posts: n/a

date functions

I have two questions:
col A -----------Col B
05-DEC-2005------01-DEC-2005
20-DEC-2005------02-DEC-2005
------19-DEC-2005

1.Which date or dates in range B1:B3 falls in range A1:A2(including both
dates) ?
or (Is any date/s in B1:B3 falls between A1 and A2?)
ans: 19-DEC-2005
2.What date in range B1:B3 is nearest to today?
ans: 19-DEC-2005
What functions will fetch me the desired results?

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
Advanced Date Functions	enright_m	Excel Worksheet Functions	1	October 26th 05 04:08 PM
Date functions	John	New Users to Excel	3	August 15th 05 08:50 PM
Date difference	Maxi	Excel Worksheet Functions	7	July 28th 05 01:38 PM
Date Math Problem	Dkline	Excel Worksheet Functions	4	March 4th 05 04:11 PM
date and time	ladimples247	New Users to Excel	2	February 16th 05 08:52 PM

All times are GMT +1. The time now is 12:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us