A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
Hi dudes, i having a bit of trouble with a spreadsheet im working on, to simplify the way i want it to work is:
If user enters anything in to Cell A1 then Cell B1 will prepopulate with the the date, the user then saves the spreadsheet and exits. I used the Today () formula, the trouble is when the user returns to the spreadsheet the following day, the date is obviously the following days date. I need to to stay the date it was when the information was entered into Cell A1.....?
|
noshua
Member
Registered: 19th Nov 08
User status: Offline
|
Had a quick look and it seems you need to keep a COPY of the FORMULA.
See the last post for more info,
http://www.ozgrid.com/forum/showthread.php?t=108289
ps; hover your mouse over the link-look-a-likes and it'll give you even more info.
|
A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
Cheers Dude
|
ajscorsa
Member
Registered: 30th Apr 02
Location: Perceton, North Ayrshire
User status: Offline
|
dont you put $ signs in the formula somewhere to keep the original date there
|
A2H GO
Member
Registered: 14th Sep 04
Location: Stoke
User status: Offline
|
quote:
Originally posted by ajscorsa
dont you put $ signs in the formula somewhere to keep the original date there
This would be eaiser if true?
|
ajscorsa
Member
Registered: 30th Apr 02
Location: Perceton, North Ayrshire
User status: Offline
|
I can't remember properly but in a finance spreadsheet I use its
=subtotal($3$,e46:e58)
the 3 is so that it counts the sub total. I'm not sure what the formula is for todays date tho. I'll have a look and report back
|
noshua
Member
Registered: 19th Nov 08
User status: Offline
|
Did you get it sorted? I can't see any other way of doing it, you can't even 'freeze' the cell.
|
Ojc
Member
Registered: 14th Nov 00
Location: Reading: Drives : Clio 197
User status: Offline
|
Yes $ might work. Put it at the start of the formula.
|
