Hey Nic and others I just tried something, and lo, it did what I was hoping. I also, I hope, did what Tim suggested. I made a discovery by trying something, On Mar 15, 2014, at 7:50 AM, Eugenia Firth <gigifi...@me.com> wrote:
> hi Nick > Thanks, and if I end up having to do time sheets, I will let you know. That > could happen because the lovely state of Washington wants me to do that for > my employee. They told me away around it, and I hope it works. > Regards, > Gigi > > Sent from my iPhone > >> On Mar 15, 2014, at 7:10 AM, Nicholas Parsons >> <mr.nicholas.pars...@gmail.com> wrote: >> and I had not a clue whether it would work. I came home and found out, yes, my formula had changed the 12th of March to today, even though I thought earlier it hadn't. So just now I typed in the equals sign and the word today and a minus sign and 3. Sure enough, the computer subtracted back three days ago from today. I hope I made it stay stationary by copying and pasting the formula back into the cell. We will see if it stays the 12th of March and the 13th tomorrow. If it doesn't, I guess I'll just have to go back to my old way and type the things in. Oh, I have another cell that copied in for today's date. We'll see if it stays. Gigi >> Hi Gigi, >> >> That's odd your today() function didn't leave a function in the cell. >> Perhaps because of the cell formatting or something? The behaviour with the >> now() function, leaving an actual function there, is more the norm as I >> understand it. From my testing, the now() function will update itself, so if >> you go back and look at it you should notice that the time outputted by the >> now() function should have changed. As I understand it, that's the point of >> those functions, so that they can update to dynamically output the current >> date/time. >> >> I'm not doing anything too flash with the date/time stuff, just keeping a >> timesheet for work. Every time I start a new task or work for a new client, >> I need to enter the start time and end time, so it's much easier if I can do >> it with one quick key press rather than typing formulas, copying and pasting >> etcetera. Otherwise keeping the timesheet starts to become a bit of a task >> in itself. >> >> Anyway, if you wanted help creating that service thing that I created, I'd >> be happy to give you step by step instructions, or just email you the file >> or something. It's really pretty simple, and I know you'd be more than >> capable of it. >> >> Best, >> Nic >> >> -- >> You received this message because you are subscribed to the Google Groups >> "MacVisionaries" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to macvisionaries+unsubscr...@googlegroups.com. >> To post to this group, send email to macvisionaries@googlegroups.com. >> Visit this group at http://groups.google.com/group/macvisionaries. >> For more options, visit https://groups.google.com/d/optout. > > -- > You received this message because you are subscribed to the Google Groups > "MacVisionaries" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to macvisionaries+unsubscr...@googlegroups.com. > To post to this group, send email to macvisionaries@googlegroups.com. > Visit this group at http://groups.google.com/group/macvisionaries. > For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "MacVisionaries" group. To unsubscribe from this group and stop receiving emails from it, send an email to macvisionaries+unsubscr...@googlegroups.com. To post to this group, send email to macvisionaries@googlegroups.com. Visit this group at http://groups.google.com/group/macvisionaries. For more options, visit https://groups.google.com/d/optout.
