View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
EileenR EileenR is offline
external usenet poster
 
Posts: 1
Default Advanced IF Formula help needed

Hi,

I would like to create a formula that does the following: calculate the
number of days between dateA and dateb. If the number of days between the 2
are more than 365 then it would return "X". If the number of days are less
than 365 it would return "N2008" if the year in dateA was 2008 or "N2009" if
the year in dateA was 2009. (eg: if dateA was 8-1-2008 it would return
"N2008", if dateA was 3/31/09 it would retun "N2009"
--
Thanks!

EileenR