Convert string to upper case

=upper(A2)
The excel formula above will convert text of any format to capital letters. For instance, if the text in cell a2 said "trust", then the formula will convert it to "TRUST".

Read More..

Trim spaces

=trim(A2)
The excel formula above will remove spaces in front and behind any text or number or date value. It does not remove spaces in between.

Read More..

Next month date function for Excel

=month(now())+1
The excel formula above will display the next month from the current month in excel. So, if this month is February, the formula will display "March".

Read More..

Previous month date function in Excel

=month(now())-1
The excel formula above will display the previous month from the current within excel. So, if the current month is February. Then Excel will display the word "January".

Read More..

Month date function in Excel

=month(now())
The excel formula above will display the current month of the year once inputted within excel. So, if we are in the month of February, the excel formula will display the word "February".

Read More..

One week in the future date function in Excel

=today()+7
The excel formula above will didplay the date in one week from the current date within excel.

Read More..

Next year's date function in Excel

=year(now())+1
The excel formula above will display next year's date within excel.  So, if the current year is 2012 then the formula will display 2013.

Read More..