| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date function
Hi,
I have 2 columns of dates , one being the start and the other the end. I need to find out if a certain month falls between a start and an end date. This is what my data looks like . Startdate Enddate May-11 Jun-11 July-11........dec-13 2/5/2011 6/10/2011 2/10/2011 6/1/2012 2/4/2011 6/12/2012 Now if may 11 falls in between any of the start or end date i need the cell to display "yes" and so on for each month. Please help! Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Function to lookup date on tab in excel and populate date on calen | Excel Worksheet Functions | |||
| Howw can I make a function return a date in date format | Excel Programming | |||
| Function Excel:If a Dateactual date create a RED alert in a cel? | Excel Programming | |||
| Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Threaded Mode
