Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
B B is offline
external usenet poster
 
Posts: 17
Default extract date between a given time frame

I have the following problem:

If a certain date falls within a certain time frame (e.g. 03/04/07 falls
within 01/01/07 till 31/12/07), than cell should display "Yes"; If it
doesn't, exel cell should display "No".

How to do this (I'm new on the block)?
Thanks
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 3,268
Default extract date between a given time frame

=IF(A2="","",IF(AND(A2=B2,A2<=C2),"Yes","No"))

where A2 holds the date you want to test for and B2 hold the lower date
limit and C2 the upper

--
Regards,

Peo Sjoblom


"B" wrote in message
...
I have the following problem:

If a certain date falls within a certain time frame (e.g. 03/04/07 falls
within 01/01/07 till 31/12/07), than cell should display "Yes"; If it
doesn't, exel cell should display "No".

How to do this (I'm new on the block)?
Thanks



Reply
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
Extract the hour from a cell showing the date and time Paul Sexton Excel Worksheet Functions 2 February 27th 06 07:15 PM
How do I sum within a set time frame from the current date? Skydiver Driver Excel Worksheet Functions 3 November 10th 05 04:43 AM
How do I calculate if a date is in a certain time frame? Pe66les Excel Worksheet Functions 19 August 27th 05 11:07 PM
How to attach legend frame to chart frame? holg3r Charts and Charting in Excel 2 July 7th 05 11:41 PM
3 Time frame 11050204 Excel Worksheet Functions 1 June 27th 05 03:05 AM


All times are GMT +1. The time now is 10:42 AM.

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"