I have the date of EXCEL in sum
[Users questions | Browse:49 | Favorites]
Users questions: I EXCEL in a grid on input "2001.1.2-2003.2.3" and then in another Gerry enter "2", then I add the two lattices, compared to display "2001.1.4-2003.2.5" that dates plus 2, I ask how to operate 77 extra points 7777 if "2001.1.2-2003.2.3" in A1, then in B1 enter: = TEXT (TEXT (SUBSTITUTE (LEFT (A1, FIND ("-", A1) -1 ),".","-") , "yyyy-mm- dd )+2, yyyy.m.d )& - &TEXT(TEXT(SUBSTITUTE(MID(A1,FIND( - ,A1)+1,100), . , - ), yyyy-mm-dd )+2, yyy ymd ")
- Cell in Excel for graphics.
- domn down the word document, how to remove shading
- Download the Google input Thunder
- PPT pie method to do? Can quickly learn
- How to restore the default browser status ie
- WORD2003 program is broken
- the difference between word and wps?
- Ask CSS problems
- Hide Add Remove Programs
- Computer system and antivirus software
- This information provided by the users.Thanks!
Computer Knowledge Copyright 2005-2015 All Rights Reserved.