![]() Renders the #VALUE error - as I mentioned before, that function cannot be applied to a date stored as a Date. That's why referring to that cell using DATEVALUE When you enter Janu(or any compliant Date) into a cell formatted as General the cell is automatically reformatted as Date because the entry is recognized by Excel as valid Date syntax. ![]() Going back to the example in your message of June 28.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |