Get Day Name From Date

TEXT(B4,"ddd"): 

If you need to get the day name (i.e. Monday, Tuesday, etc.) from a date, there are several options depending on your needs.

Do you just want to display the day name?

"ddd"  // "Wed"
"dddd" // "Wednesday"

Excel will display only the day name, but it will leave the date value intact.

Do you want to convert the date into a day name?

If you want to convert the date value to a text value, you can use the TEXT function with a custom number format like "ddd". The formula looks like this:

=TEXT(B4,"DDD")

The TEXT function converts values to text using the number format that you provide. Note that date is lost in the conversion, only the text for the day name remains.

MAIL MERGE

        Mail Merge is a useful tool that allows you to produce multiple letters, labels, envelopes, name tags, and more using information stored in a list, database, or spreadsheet. When performing a Mail Merge, you will need a Word document(you can start with an existing one or create a new one) and a recipient list, which is typically an Excel workbook.

To use Mail Merge:

1. Open an existing Word document, or create a new one.
2. From the Mailings tab, click the Start Mail Merge command and select Step by Step Mail Merge Wizard from the drop-down menu.
3. 
   
   

       The Mail Merge pane appears and will guide you through the six main steps to complete a merge. The following example demonstrates how to create a form letter and merge the letter with a recipient list.

RANDBETWEEN Function in Excel

Returns a Random Number within a specified  Range (bottom,top). It returns an integer between any two defined values – such as one and ten.

RANDBETWEEN Function Syntax

The syntax for RANDBETWEEN function is:

=RANDBETWEEN( bottom, top )

Bottom – The lower number of the range and the smallest integer value that the function will return.

Top – The higher number of the range and the largest integer value that the function will return.

RANDBETWEEN Function Example

Have a look at RANDBETWEEN function examples

Macro Code for Displaying the Names of Worksheets One by One.

Using Macro Code Displaying the Names of Worksheets in a Workbook.

After executing this code it displaying all worksheets names one by one.

MACRO CODE:

Sub for_each()                  
Dim sh As Worksheet
For Each sh In Worksheets      'For Each Loop
MsgBox sh.Name                    'Msgbox diplaying the Names
Next sh
End Sub


F5 - Execute the Program

How to find number of years Between Two Dates

Finding No.of Years Between Two Dates

Here We are using Datedif( ) Function to finding Difference between Two Dates.

If we want to find No.of Months in between two dates then.

=DATEDIF(D2,B2,"M")

And For No.of Days

=DATEDIF(D2,B2,"D")

By using this function we can find Months in a year, Days in a Month also.

=DATEDIF(D2,B2,"YM")     -> Remaining Months After Years.

=DATEDIF(D2,B2,"MD")     -> Remaining Days After Months 

EXCEL MAP - Excel and Macros TIPS
===============================
MATCH - Finding the position of a Given array items.

EXCEL MAP - REPT() Function Use
==============================
Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
For More Excel Updates www.facebook.com/groups/EXCELMAP