=CDate(Now).ToString("MM-dd-yyyy") =Format(Today(),"MM-dd-yyyy") Note: Now() will show you current date and time stamp Today() will show you Date only not time part. Also you can set any date format instead of MM-dd-yyyy in my example.
=CDate(Now).ToString("MM-dd-yyyy") =Format(Today(),"MM-dd-yyyy") Note: Now() will show you current date and time stamp Today() will show you Date only not time part. Also you can set any date format instead of MM-dd-yyyy in my example.