View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ray Everingham
 
Posts: n/a
Default URGENT IF STATEMENT REQUIRED:True if moving between financial years?


Sorry about multiposting. My first time here.

The situation I have is that I have one date in cell A1 and another
date in cell A2. What I am trying to find out is first, if there is a
logical or financial function that will return TRUE if the financial
year in cell B2 has moved on a year. For example, A1=01/05/06, B1=
01/04/07, Answer=TRUE.

I do apologise if this is a question that has been asked a thousand
times before. If you can direct me to where I can find the answer in a
FAQ then great.


--
Ray Everingham
------------------------------------------------------------------------
Ray Everingham's Profile: http://www.excelforum.com/member.php...o&userid=34822
View this thread: http://www.excelforum.com/showthread...hreadid=545760