I am trying to configure a spreadsheet to allow the user to enter a date to track when people arrive and leave. The Now() function will update. I was trying to use Now in a function by creating a Module in my spreadsheet (Excel 2007)
' Returns static date
StaticDate = Now
This function works, but I want to assign it to a keyboard shortcut, but I can not figure out how to do that in Excel 2007
Is my function the easiest way to add the static date?