Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way for excel to see if a date is in a specified range?
Hi all, I'm trying to figure this one out.. I'm sure its possible, but we'll
see. I'm trying to find out how I can have it to where it'll read a date in a column, and if its between 2 dates, it'll populate two different results. For example, the date I enter is 3/15/08. I want it to be able to check to see if the date is between 3/1/08 and 4/1/08, if it is, it'll populate in a cell the word "Redet" if the values are true, and "App" if the values are false. Reason is, I work with medicaid and am trying to generate a calculator to help employees determine whether programs are timely renewals are not. My second part of this question, is if I add an activex object like a radio button, Is there a way to make it so when a radio button is selected, it'll read a certain range of dates? I plan on doing 12 radio buttons, (one for each month of course) with different date ranges.. Thanks for your help guys. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Is there a way for excel to see if a date is in a specified range?
For your first problme -
You need to enter a formula like; =IF (AND(C1A1, C1<B1),"Redet","App") where you have the date to compare in C1, lower range in A1 and upper range in B1. "offdah3z" wrote: Hi all, I'm trying to figure this one out.. I'm sure its possible, but we'll see. I'm trying to find out how I can have it to where it'll read a date in a column, and if its between 2 dates, it'll populate two different results. For example, the date I enter is 3/15/08. I want it to be able to check to see if the date is between 3/1/08 and 4/1/08, if it is, it'll populate in a cell the word "Redet" if the values are true, and "App" if the values are false. Reason is, I work with medicaid and am trying to generate a calculator to help employees determine whether programs are timely renewals are not. My second part of this question, is if I add an activex object like a radio button, Is there a way to make it so when a radio button is selected, it'll read a certain range of dates? I plan on doing 12 radio buttons, (one for each month of course) with different date ranges.. Thanks for your help guys. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating date range for x-axis label in Excel '07 | Excel Discussion (Misc queries) | |||
How do I stop Excel interpretting a number range as a date? | Excel Discussion (Misc queries) | |||
excel - access query - date range | Excel Discussion (Misc queries) | |||
How do I count items within a date range in Excel? | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions |