Excel

EDATE EOMONTH I used EDATE to find the nth month later of the date, 07/14/2024. I also used Emonth to find the end of the month with respect to that date. If I go one month back, which will return the end of June (06) month then add 1, this will result with the first day of month.

LEFT, RIGHT, MID, LEN, FIND To find the whole number: 1) Use LEFT function because whole number is left of the decimal 2) FIND position of decimal and then subtract 1 (this will allow user to return everything before the decimal) To find the first name: 1) Use LEFT function because first name is left of the space 2) FIND position of space and then subtract 1 (this will allow user to return everything before the space) To find the last name: 1) Use the RIGHT function because last name is right of the space 2) Find the length of the full name using LEN function 3) FIND position of space 4) Subtract and get difference between length of full name and position of space (the full length minus characters spots the first name and space is using will result in the number of spots the last name is using)

Left, Right, & Mid Extract characters using the left, right, and mid function.  It was super useful to use the mid function to extract the area code and landline number (the 7 numbers after the area code). There is more to learn such as using FIND and LEN functions and combining them together.