Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have a database that i'm working on. There are 5000 contacts. I have to
figure out if a contact has had their car serviced in december to receive a svc. letter or if they have had their car serviced after 12/04. Some of them have dates in dec. and after. Should i be using the =EXTRACT function... or the IF function? I am lost....please help.! thanks!! CUSTOMER NAME S-LTDATE AUTO EAST 10-Dec-04 AUTO EAST 14-Dec-04 AUTO EAST 16-Dec-04 AUTO EAST 11-Jan-05 AUTO EAST 18-Feb-05 AUTO EAST 23-Feb-05 AUTO EAST 2-Mar-05 no need to send these because serviced after 12/04 AJEMIAN,LAURIE B 21-Dec-04 AJEMIAN,LAURIE B 31-Dec-04 must send service letter nothing after 12/04 ALBEE,WINN A 30-Dec-04 ALBEE,WINN A 29-Jan-05 no need to send these/serviced after 12/04 ALGONQUIN GAS TRANS CO. 10-Dec-04 ALGONQUIN GAS TRANS CO. 16-Dec-04 ALGONQUIN GAS TRANS CO. 24-Feb-05 no need to send these/serviced after 12/04 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
Conversion | Excel Worksheet Functions | |||
Trim function doesn't clean out ASCII Code 160 (Space) | Excel Worksheet Functions | |||
Formula to list unique values | Excel Worksheet Functions | |||
Counting Function Dilemma | Excel Worksheet Functions |