| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Dates
Hello
I need to compare a number in one cell to a date in another to see if they match (I am matching the day in the date). A B 15 02/15/09 =true 23 01/23/09 =true 1 05/11/08 =false 3 02/30/09 =false Can this be done? Thanks....... 30 01/30/09 15 02/15/09 1 02/01/09 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Dates
If I understand what you want:
=A1=DAY(B1) Copy down as needed. -- Biff Microsoft Excel MVP "teresa" wrote in message ... Hello I need to compare a number in one cell to a date in another to see if they match (I am matching the day in the date). A B 15 02/15/09 =true 23 01/23/09 =true 1 05/11/08 =false 3 02/30/09 =false Can this be done? Thanks....... 30 01/30/09 15 02/15/09 1 02/01/09 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Dates
I can believe the solution was so simple.
Thank you very much!!!! "T. Valko" wrote: If I understand what you want: =A1=DAY(B1) Copy down as needed. -- Biff Microsoft Excel MVP "teresa" wrote in message ... Hello I need to compare a number in one cell to a date in another to see if they match (I am matching the day in the date). A B 15 02/15/09 =true 23 01/23/09 =true 1 05/11/08 =false 3 02/30/09 =false Can this be done? Thanks....... 30 01/30/09 15 02/15/09 1 02/01/09 |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Dates
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "teresa" wrote in message ... I can believe the solution was so simple. Thank you very much!!!! "T. Valko" wrote: If I understand what you want: =A1=DAY(B1) Copy down as needed. -- Biff Microsoft Excel MVP "teresa" wrote in message ... Hello I need to compare a number in one cell to a date in another to see if they match (I am matching the day in the date). A B 15 02/15/09 =true 23 01/23/09 =true 1 05/11/08 =false 3 02/30/09 =false Can this be done? Thanks....... 30 01/30/09 15 02/15/09 1 02/01/09 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stop dates from showing as numbers - when formated as dates | Excel Discussion (Misc queries) | |||
| compare 2 tables of dates to find the preceding dates | Excel Worksheet Functions | |||
| Identifying unique dates in a range of cells containing dates... | Excel Discussion (Misc queries) | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Charting data against dates where dates are not at fixed intervals | Charts and Charting in Excel | |||
Linear Mode
