Thread: Date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ren Ren is offline
external usenet poster
 
Posts: 67
Default Date

Hello,

I am doing a little assignment for school.

I have a product name P1- and I have sold it during 2 years: 2005 and 2006.
All of those sales with different months and days.
The name needs to be change- it is renamed P1-Turbo in 2006

How can I do that? Can I use an IF function? If so, how can I input the date
if the data contains different days and months???


Thanks