Home |
Search |
Today's Posts |
#1
|
|||
|
|||
insert DATE automatically
I have a worksheet,that has to be updated everyworking day of my company.How
to insert today's date below yesterday's(or last working day) date in date column,what function will insert today's date automatically after 12 in midnight by considering the date is working day or not? |
#2
|
|||
|
|||
Hi Tungana,
See http://www.mvps.org/dmcritchie/excel/event.htm#autodate You should read the material at top as well, but it is an Event macro and is installed differently than other macros. Right Click on the workseet tab, View Code, plop in the code from the above. When you type something into Column B, the date in Column A will be filled in automatically. There is also a shortcut available Ctrl+; (semicolon) which will use the short date form in your Regional Settings (control panel) http://www.mvps.org/dmcritchie/excel/shortx2k.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "TUNGANA KURMA RAJU" wrote in message ... I have a worksheet,that has to be updated everyworking day of my company.How to insert today's date below yesterday's(or last working day) date in date column,what function will insert today's date automatically after 12 in midnight by considering the date is working day or not? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert date in macro | New Users to Excel | |||
search for latest date | Excel Worksheet Functions | |||
how do i automatically insert the current author's name in a cell. | Excel Worksheet Functions | |||
How do I insert the date the file was saved in the MS Excel foote. | Excel Discussion (Misc queries) | |||
Function to automatically insert a new sheet as a result of data entry? | Excel Worksheet Functions |