Passing date as optional parameter to function

I want to create a function to return a value from a sheet. The first parameter is a account number that must be passed. The second parameter is a date but that I want as an optional parameter. So if a date is entered use that date otherwise use today date as parameter.

Please Login or Register  to view this content.

What do I enter for = !!!?

Or do I have to leave out the = !!! part and set it inside the function?

How do I check inside the function if the date was passed or not?

Dates in VB/VBA is a pain for me

romperstomper. Comparing it to 0 does the job.

Sixthsence: If I display the variable without assigning a date to it it only displays 12:00:00 AM. It doesn't display a date.

Debraj Roy: I prefer not to use variants if at all possible. My var is declared as a date.

Thanks people.