Today's Date

[Marc Harmon]

Excel help syntax leads me to think that I only need write NOW() In list
function, to get today's date whenever I enter something in this row. No
such luck. Obviously I am missing something?
What?
Marc

 

[JE McGimpsey]

Excel help syntax leads me to think that I only need write NOW() In list
function, to get today's date whenever I enter something in this row. No
such luck. Obviously I am missing something?
What?

NOW() returns both date and time (XL stores dates as integer offsets
from the base date, and time is fractional days, so 5/4/2004 6:00 am is
stored as 36649.25

The TODAY() function returns only the integer part.

Both functions are volatile and update whenever the worksheet is
recalculated.

If you're interested in a timestamp instead (i.e., one that only updates
when the cell in that row is changed), take a look at

http://www.mcgimpsey.com/excel/timestamp.html

 

[Marc Harmon]

This is for a complex accounting workbook. (Check Register, Bank Statement,
Payroll, 941, Profit and loss statement, Proforma budget, Deposit-prorata,
donations statement, etc.)

Can anyone suggest any websites to download some samples of such complex
workbooks with associated Macros that I can get some ideas?

I am using this DATE MACRO to enter the day (1-31) in a list (on a
worksheet) in the column - Date. The list starts with a row or two and can
grows to 10 or as many as 40 entries (months activity). Besides dedicating
a whole column of the worksheet, what terminology in the macro would limit
it to this column in the list. OR..

Further::
There are 12 lists one for each month.
They are identical in form different in that each is just a different month.
Therefore the date will be represented by only a single or double digit
number.

Is there a way to get that date macro to show up in the List wizard or other
easy way to use this same macro for each list (thus variable columns
addresses - letters A thru DD)

Further More::
I have been dragging and dropping the lists, and then correcting any
resulting cell reference errors.
Perhaps what I need is a macro or script to make a list when needed and then
it could have all the formulas corrected by cell numbers.

Marc