Remember Me?

#1
September 19th 08, 09:30 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Jun 2008 Posts: 11
Need a formula to determine if date falls within a date range then

Help.

Cell A1 = 16/1/08
Cell A2 = 1/1/08
Cell A3 = 28/1/08
Formula needed for Cell A4

I would like a formula for:
Cell A4= if A1 =A2 and <=A3 them retuen X

appreciate the help.

#2
September 19th 08, 09:35 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2007 Posts: 11,501
Need a formula to determine if date falls within a date range then

Try,

=IF(AND(A1=A2,A1<=A3),"x","")

Mike

"Corca" wrote:

Help.

Cell A1 = 16/1/08
Cell A2 = 1/1/08
Cell A3 = 28/1/08
Formula needed for Cell A4

I would like a formula for:
Cell A4= if A1 =A2 and <=A3 them retuen X

appreciate the help.

#3
September 19th 08, 09:36 AM posted to microsoft.public.excel.worksheet.functions
 external usenet poster First recorded activity by ExcelBanter: Apr 2008 Posts: 1,766
Need a formula to determine if date falls within a date range then

Hi,

If(and(A1=A2,A2<=A3),"X","whatever")

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Corca" wrote in message
...
Help.

Cell A1 = 16/1/08
Cell A2 = 1/1/08
Cell A3 = 28/1/08
Formula needed for Cell A4

I would like a formula for:
Cell A4= if A1 =A2 and <=A3 them retuen X

appreciate the help.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Keep It Simple Stupid Excel Worksheet Functions 4 August 28th 07 10:02 PM dustin Excel Worksheet Functions 3 December 9th 06 02:01 AM Nokose451 Excel Discussion (Misc queries) 1 January 16th 06 10:06 PM clovins1 Excel Worksheet Functions 2 October 9th 05 02:14 AM Cat Excel Worksheet Functions 4 September 17th 05 03:01 AM

All times are GMT +1. The time now is 03:36 AM.