Thread: [Solved] formula in excel 2007 works not in 2013
View Single Post
 
Old 07-04-2015, 02:55 PM
piper7971 piper7971 is offline Windows Vista Office 2007
Advanced Beginner
  
Join Date: Jul 2010
Posts: 38
piper7971 is on a distinguished road
Default formula in excel 2007 works not in 2013
Hi!
I am using this formula in a worksheet I created in excel 2007 but when someone open the worksheet using excel 2010 or 2013 it doesn't work it change all the numbers to #. Any ideas why?

=IF(M8="","",IF(WEEKDAY(M8)=2,"L",IF(WEEKDAY(M8)=3 ,"K",IF(WEEKDAY(M8)=4,"M",IF(WEEKDAY(M8)=5,"J",IF( WEEKDAY(M8)=6,"V",""))))))

this is for a calendar.

thanks!
Reply With Quote