

HLOOKUP Range Lookup Table with Absolute References
Roman Kondtratiuk
Date and time functions can be used in Excel to display current updated time and date information.
Dates can also be used to display, for example, a sequence of week days, and numerical value of days between 2 dates.