View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Check date and act on it

if lcase(format(cell,"mmmm")) = "february" then

--
Regards,
Tom Ogilvy


"ladyhawke" wrote:

I have a set of data imported to my spreadsheet using a macro. One of
the fields in that set is a Date...

I want to compare the month of the date to a string and add the line of
data to another spreadsheet accordingly....

How can this be done?

regards,
ladyhawke