| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date functions
I am trying to get information using a date.
A B C D 04/28/06 64 1 0 I wrote =IF(A227,B2,C1) -- DMM |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date functions
Check your other post
"Dianethetech" wrote: I am trying to get information using a date. A B C D 04/28/06 64 1 0 I wrote =IF(A227,B2,C1) -- DMM |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date functions
Sorry Mike, this is my first time trying to use this and I can't find my
other posting. -- DMM "Mike" wrote: Check your other post "Dianethetech" wrote: I am trying to get information using a date. A B C D 04/28/06 64 1 0 I wrote =IF(A227,B2,C1) -- DMM |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date functions
Try this:
=IF(DAY(A2)27,B2,C1) "Dianethetech" wrote: I am trying to get information using a date. A B C D 04/28/06 64 1 0 I wrote =IF(A227,B2,C1) -- DMM |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date functions
Thanks, that works great.
-- DMM "Teethless mama" wrote: Try this: =IF(DAY(A2)27,B2,C1) "Dianethetech" wrote: I am trying to get information using a date. A B C D 04/28/06 64 1 0 I wrote =IF(A227,B2,C1) -- DMM |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date functions | Excel Worksheet Functions | |||
| Date Functions | Excel Worksheet Functions | |||
| Date Functions | Excel Discussion (Misc queries) | |||
| Date and Sum functions (HELP) | Excel Discussion (Misc queries) | |||
| Date Functions | Excel Discussion (Misc queries) | |||
Hybrid Mode
