![]() |
#1
|
|||
|
|||
![]()
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! |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
gbaker | Excel | 1 | 04-26-2014 12:31 AM |
Excel 2007 - formula or macro/vba code required | wrighty50 | Excel Programming | 3 | 05-13-2012 02:24 PM |
2007 office key no longer works | millertime | Office | 6 | 02-19-2012 07:50 PM |
Is there a graphic tutorial available on how the Word 2007 ruler works? | Jenjen80 | Word | 0 | 07-13-2010 07:41 PM |
Works 9 Upgrade to Office 2007 Standard | TXJAWA | Office | 0 | 05-03-2010 07:49 AM |