GDATE returns the start date or end date for the specified group/offset.

SYNTAX:

GDATE(Start/End Flag,Grouping/EndDate, GroupOffset/StartDate, optional Format) 

Start/End Flag:  Enter 1 to get the start date. Enter 2 to get the end date. All other numbers may return unknown results.

Grouping/EndDate: Used to set which dates to calculate the stat for.  If the Grouping is a date literal string (i.e. "07/16/2004") or refers to a cell with a date in it, it is assumed to be the end date to calculate the stat for. Common Groupings are:

"D" Days
“M” Monthly 
"R" Report Dates
Click here for available Grouping options

GroupOffset/StartDate: Used with the Grouping parameter to set the dates to calculate the stat for.  Sets the number of Groups (set by the Grouping Parameter) to be added to set the dates.  See examples below. If this field is a date string (i.e. "07/16/2004") or refers to a cell with a date in it, it is assumed to be the start date to calculate the stat for.

Format:  The format that the date will be outputted. See here for format explanation. This is an optional parameter.

NOTES:

Start dates and end dates can be changed when choosing the dates you are reporting. This will changed the output of this function automatically.

EXAMPLES:

In the above example the cells contain (from top to bottom):

GDATE(1,"M",1)  Returns the start date in standard format

GDATE(2,"M",1)  Returns the end date in a standard format

GDATE(1,"M",1,"MM/DD/YYYY")  Returns the start date in a specified format

GDATE(2,"M",1,"MM/DD/YYYY")  Returns the end date in a specified format

GDATE(1,"M",1,"DD")  Returns only start day.

GDATE(2,"M",1,"DD")  Returns only the end day.