Using Weekday function in Excel

=Weekday(now())
The above formula will display the current day of the week. For example, if you entered this formula in a cell within excel on a Monday. Then the formula will display the word "Monday".

Read More..

Using Tomorrow date function in Excel

=today()+1
The excel formula above will display tomorrow's date within excel. So, if today was the 01/01/2014 the formula would display 02/01/2014.

Read More..

Year function

=year(now())
The excel formula above will display the current year as set on your computer.

Read More..

Month function in Excel

=month(now())
The excel formula above will give you a display of the current month in excel as set on your computer.

Read More..

Using Addition in Excel

=A2+B2
The formula above will add the value of cell A2 to the value of cell B2.

Read More..

Yesterday's Date Function in Excel

=today()-1
The formula above will give you yesterday's date.  It does this by subtracting one day from today's date.

Read More..

One week ago date function in Excel

=today()-7
The excel formula above will the date of 1 week ago. It will do this be subtracting seven days from todays date.

Read More..