For Example
Create Calculated column called "EMP-01" and type in this formula
=LEFT([ID],INT(FIND("-",[ID])-1))
Result :
EMP
Create Calculated column called "Employee ID" and type in this formula
=RIGHT([ID],LEN([ID])-INT(FIND("@",[ID])))
Result:
...
Showing posts with label Calculated Column. Show all posts
Showing posts with label Calculated Column. Show all posts
Monday, July 4, 2016
Thursday, June 9, 2016
[Me] in de View Filter settin...
Thursday, May 5, 2016
We will create the Calculate Column
Example for Month
=TEXT([columname],"MM")
Example for Year
=TEXT([columname],"YYYY")
Example for Date
=TEXT([columname],"DD")&nbs...
Tuesday, March 15, 2016
15
Mar
Week starts on monday. Depending on your regional settings you have to replace the ; with ,
Example:
=IF(INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7)=0;52;INT((StartDate-DATE(YEAR(StartDate);1;1)+(TEXT(WEEKDAY(DATE(YEAR(StartDate);1;1)-1);"d")))/7))
Example:
=INT(([Start...
Saturday, October 17, 2015
=TEXT([Date],"mm") => date is 1-Jun-2015
Result:
06
=TEXT([Date],"mmmm") => date is 1-Jun-2015
Result:
January
=TEXT([Date],"mmm") => date is 1-Jun-2015
Result:
Jan
=TEXT([Date],"yyyy") => date is 1-Jun-2015
Result:
2015
=TEXT([Date],"dd") => date is 1-Jun-2015
Resul...
Posts
