Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hey all,
My boss asked me to come up with a spreadsheet that logs the type of computer problem we've had and what we did to fix. He also wants each entry to be dated in automatically, to make things easier. So, I tried using the NOW() forumla in the following way: =IF(ISBLANK(A2),"",NOW()) This would immediatly paste the current date if anyone entered in a name entry. The only problem I ran into was that the NOW() function continually updates, even after the entry is put in. So all of my data entries end up looking like the same date. My question: Is there a way to do this with the date remaining static, like a stamp almost, when it's entered? Thanks! I appreciate any help you guys and girls can provide. -Tinker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
grouping dates by week/month/etc. on cat. axis | Charts and Charting in Excel | |||
Ploting dates against a calendar and not as a simple events | Charts and Charting in Excel | |||
Entering dates QUICKLY | Excel Discussion (Misc queries) | |||
Dates | Excel Discussion (Misc queries) | |||
Dates in spreadsheets | Excel Discussion (Misc queries) |