Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a way to set up a one-time default date?
I am trying to make my template extremely user friendly. Every year I add
one or two upgrades to my companies timesheet template. This year I am going all out and making it nearly effortless to create and fill in. The idea is that if the redundant, brainless information is filled in for you then you can spend more time writing descriptions for every time entry. What I am trying to do now is to help fill in the date field. I have already created a single pull-down with validation which will only allow for a Monday date to be used via a list of Monday dates I entered into a 'data' sheet. If any of you know of a better way to handle this, which will eliminate the need for me to update this list every year, please let me know. I don't plan to work here forever and I don't want to leave them with a template which will eventually become obsolete if it is not maintained. But the real meat-and-potatoes of my question is - is there a way to set a date cell in the one-and-only time that the template is called upon to start a new timesheet (bi-weekly)? I have set auto-date fields before only to be disappointed when it updates every single time the file was accessed. Ideally it should insert the closest Monday's date and allow the user to change it (in case the timesheet is being done before or after it's given time) via the validation drop-down I explained above. I also plan to do a similar task which the template should auto-fill in a user's name according to what the current user's login is. I hope I didn't make my question more complicated than necessary. TIA Jeffrey K. Ries |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default date and time in the comment. | Excel Worksheet Functions | |||
HOW DO YOU SET THE DEFAULT TIME FOR DATE IN EXCEL TO 8:00 AM? | Excel Discussion (Misc queries) | |||
How do I get the default workbook settings to print the date/time/ | Excel Discussion (Misc queries) | |||
Problem with default date/Time | Excel Worksheet Functions | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions |