LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Galway
 
Posts: n/a
Default IF function?

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks using R[1]C[1] and offset function in its cell referenc Elijah-Dadda Excel Worksheet Functions 0 March 5th 05 03:31 AM
Conversion SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM
Trim function doesn't clean out ASCII Code 160 (Space) Ronald Dodge Excel Worksheet Functions 6 January 27th 05 03:48 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
Counting Function Dilemma Simon Lloyd Excel Worksheet Functions 0 November 8th 04 03:13 PM


All times are GMT +1. The time now is 04:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"