Microsoft project function reference

This browser is no longer supported. Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? How is this e-book different? And how can it help you? The e-book gives you a process In Microsoft Project, it is very important to follow the right sequence of steps when setting up a new project.

What do you do if cost rates change during the project? How to set different working times for individual people? How do you handle change requests? Finally, you might be wondering if the guide is right for you. Let me answer your question. Same range as String for non-numerics. Returns a Variant Date for a specified year, month, and day. DateSerial year , month , day. Number between and , inclusive, or a numeric expression. Any numeric expression. However, date can also be any expression that can represent a date, a time, or both a date and time, in that range.

Returns a Variant Integer specifying a whole number between 1 and 31, inclusive, representing the day of the month. If date contains Null , Null is returned. Returns a Variant Integer specifying a whole number between 0 and 23, inclusive, representing the hour of the day. If time contains Null , Null is returned. Returns a Variant Integer specifying a whole number between 0 and 59, inclusive, representing the minute of the hour.

Returns a Variant Integer specifying a whole number between 1 and 12, inclusive, representing the month of the year. Returns a Variant String representing the octal value of a number. The expression to convert to a date. Set on the View tab in the Options dialog box Tools menu.

The expression to convert to a duration. The units used to express the duration. If durationunits is not specified, the default value is the type of units specified in the Duration is entered in option on the Schedule tab of the Options dialog box Tools menu.

The durationunits can be one of the following pjFormatUnit constants:. Returns a Variant Integer specifying a whole number between 0 and 59, inclusive, representing the second of the minute. Returns a Variant String representation of a number. Returns a Variant String converted as specified. The sum of values specifying the type of conversion to perform.

The system LocaleID is the default. Returns a Variant Date containing the time for a specific hour, minute, and second. TimeSerial hour , minute , second. Number between 0 A. Returns a Variant Date containing the time. However, time can also be any expression that represents a time in that range.

Returns a Variant Integer containing a whole number representing the day of the week. If not specified, Sunday is assumed. Returns a Variant Integer containing a whole number representing the year. Returns a Variant Date containing the current system date. Returns a Variant Date containing a date to which a specified time interval has been added. DateAdd interval , number , date. It can be positive to get dates in the future or negative to get dates in the past.

Returns a Variant Long specifying the number of time intervals between two specified dates. DateDiff interval , date1 , date2 [, firstdayofweek [, firstweekofyear ]]. Two dates you want to use in the calculation. If not specified, the first week is assumed to be the week in which January 1 occurs. Returns a Variant Integer containing the specified part of a given date. DatePart interval , date [, firstdayofweek [, firstweekofyear ]]. If not specified, the first week is assumed to be in the week in which January 1 occurs.

Returns a Boolean value indicating whether an expression can be converted to a date. Returns a Variant Date specifying the current date and time according your computer's system date and time. The original date to which duration is added. The duration to add to date. The calendar to use when calculating the new date.