LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Return info based on Date Range


I need to have a date returned based on a date range.

Basically IF Cell A1 is between 1/1/06 and 1/31/06 then place the date
of A1 into cell B6.

But I don't understand how to input a date range into Excel.

Heeeeeeeeelp!


--
kermitforney
------------------------------------------------------------------------
kermitforney's Profile: http://www.excelforum.com/member.php...o&userid=32536
View this thread: http://www.excelforum.com/showthread...hreadid=560409

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Return Range of Numerical Values in Single Column based on Frequency Percentage Sam via OfficeKB.com Excel Worksheet Functions 9 October 28th 05 11:01 PM
Counting unique records based on date range aspAddict Excel Worksheet Functions 3 October 26th 05 08:12 PM
Help PLEASE! Not sure what answer is: Match? Index? Other? baz Excel Worksheet Functions 7 September 3rd 05 03:47 PM
overtime formula based on dynamic date range? kalika Excel Worksheet Functions 2 August 28th 05 08:40 AM
Update cell based on date range deversole Excel Discussion (Misc queries) 3 July 6th 05 01:58 PM


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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"