Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract the hour from a cell showing the date and time | Excel Worksheet Functions | |||
How do I sum within a set time frame from the current date? | Excel Worksheet Functions | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
How to attach legend frame to chart frame? | Charts and Charting in Excel | |||
3 Time frame | Excel Worksheet Functions |