A constant is an identifier whose associated value cannot typically be altered by the program during its execution.
Examples of Date/Time constants within functions:
*Today is October 10, 2012
|Function(s)||Result||Function with constant||Result|
|TODAY()||Oct 10, 2012 12:00:00 AM||TODAY()-5h||Oct 09, 2012 07:00:00 PM|
|TODAY()||Oct 10, 2012 12:00:00 AM||TODAY()+8h+5m||Oct 10, 2012 08:05:00 AM|
Example of Date/Time constant within a filter:
Apply a Filter and choose Advanced
Type in the filter you wish to apply including time constant if needed.
View the data on the filtered sheet
Example of Date/Time constant within a formua:
Open a calculation workbook sheet and create your formula
View the formula results