| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
dates and number
hi again
is it possible to look-up part numbers ? and compare dates i.e. in the below.. can the year "2003" be compared to the 1st 4 ditgets of the Reg number and return False if not Reg. No. D.O.B 2003101871005 22/12/2003 regards Malcolm |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates and number
I'm not sure what you mean by lookup, but you could compare the first 4
characters of A1 with the year of the date in B1 with: =if(left(a1,4)=text(b1,"yyyy"),"same","different") EngelseBoer wrote: hi again is it possible to look-up part numbers ? and compare dates i.e. in the below.. can the year "2003" be compared to the 1st 4 ditgets of the Reg number and return False if not Reg. No. D.O.B 2003101871005 22/12/2003 regards Malcolm -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
dates and number
PERFECT
exactly what i need thanks Dave "Dave Peterson" wrote: I'm not sure what you mean by lookup, but you could compare the first 4 characters of A1 with the year of the date in B1 with: =if(left(a1,4)=text(b1,"yyyy"),"same","different") EngelseBoer wrote: hi again is it possible to look-up part numbers ? and compare dates i.e. in the below.. can the year "2003" be compared to the 1st 4 ditgets of the Reg number and return False if not Reg. No. D.O.B 2003101871005 22/12/2003 regards Malcolm -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I want to count the total Number of dates between two dates How? | Excel Worksheet Functions | |||
| Calculate next number using dates? | Excel Worksheet Functions | |||
| Number of sundays between two dates | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
| Need number of Saturdays and number of Sundays between 2 dates | Excel Worksheet Functions | |||
Linear Mode
