If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 Need a formula to determine if date falls within a date range then
 Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

## Need a formula to determine if date falls within a date range then

#1
September 19th 08, 09:30 AM posted to microsoft.public.excel.worksheet.functions
 Corca external usenet poster 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
 Mike H external usenet poster 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
 Ashish Mathur[_2_] external usenet poster 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.

 Thread Tools Display Modes Linear Mode

 Posting Rules You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off
 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home Excel Newsgroups     Excel Discussion (Misc queries)     Setting up and Configuration of Excel     New Users to Excel     Excel Worksheet Functions     Links and Linking in Excel     Charts and Charting in Excel     Excel Programming About ExcelBanter     About this forum

 Similar Threads Thread Thread Starter Forum Replies Last Post If date in cell falls between date range... Keep It Simple Stupid Excel Worksheet Functions 4 August 28th 07 10:02 PM Need true or false if a date falls between a date range dustin Excel Worksheet Functions 3 December 9th 06 02:01 AM Return a specified date when it falls within a range.... Nokose451 Excel Discussion (Misc queries) 1 January 16th 06 10:06 PM Can I check if a date falls between a range then sum other # if tr clovins1 Excel Worksheet Functions 2 October 9th 05 02:14 AM Formula to determine whether number falls within range?? Cat Excel Worksheet Functions 4 September 17th 05 03:01 AM

All times are GMT +1. The time now is 11:33 AM.