View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TUNGANA KURMA RAJU TUNGANA KURMA RAJU is offline
external usenet poster
 
Posts: 171
Default How to compare a date with financial year

I have a date in a cell and financial year in another cell.How to compare
whether that date exists in that financial year?.
example: cell a2=05-May-2007 and cell B2=2007-08.
What function will tell that a2 date exists in b2 financial year.