Skip navigation

Month formula issue

205 Views 1 Reply Latest reply: Jan 30, 2013 9:13 PM by wwjasond RSS
wwjasond Calculating status...
Currently Being Moderated
Jan 30, 2013 8:39 PM

I just noticed that my sumif formulas were not returning the same values they had previously (not sure when my problem started).  I traced the problem to a formula month(A2) & "/" & year(A2) with the month of February.  Thanks to the slowness of one workbook in the iCloud I was able to determine if A2 said 02/10/2012 then my formula would display 2/2012 unless you changed the format then real quickly you would see March 1, 2012 before reverting back to the intended format of 2/2012.  This causes the items being summed based on the formula above to be summed in the month of March with February have a 0 sum.  I have this problem with no other months.  Excel on my Macbook does not have any issues with the formula.  Any ideas what may be causing this now and how to fix it? 

iPhone 5, iOS 6.1

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.