Results 1 to 3 of 3

Thread: Today formula

  1. #1
    Join Date
    Feb 2009
    Location
    fareham
    Posts
    7

    Today formula

    I have formula that reads a cell if another cell equals today. Is there any way that this data can automatically frozen, so that the data remains when I open up the spreadsheet tomorrow.

    Example: =IF(A4+TODAY(),B4), where B4 is a date that I wish to capture a value and B4 is the reference value, which will change daily. I have a list of dates that I wish to self populate, but not lose the data when it changes to a different date, I hope this makes sense.

  2. #2
    Join Date
    May 2008
    Posts
    4,345

    Re: Today formula

    If I am correct, you want the data in the cells that have been modified with the equality formula to be intact even after the date changes. I dont this such automatic freezing is possible... not sure. You can see here if it can help you,
    http://www.timeatlas.com/mos/5_Minut...Retains_Focus/
    http://spreadsheets.about.com/od/exc...reeze_pane.htm

  3. #3
    Join Date
    Feb 2009
    Location
    fareham
    Posts
    7

    Re: Today formula

    Thanks for trying, but the sites you referred me to were to freeze panes, what I am trying to achieve is freezing data after the event.

Similar Threads

  1. Limbo Game out Today on PSN
    By ADELYN in forum Video Games
    Replies: 6
    Last Post: 06-08-2011, 10:17 PM
  2. How much VRAM do you need for today's games
    By Crista in forum Motherboard Processor & RAM
    Replies: 5
    Last Post: 27-08-2010, 03:25 AM
  3. Ubuntu 9.10 Releasing Today?
    By Rudra.J in forum Operating Systems
    Replies: 4
    Last Post: 29-10-2009, 12:48 PM
  4. Top games today
    By dramphy in forum Video Games
    Replies: 10
    Last Post: 20-10-2008, 05:45 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,690,088.26832 seconds with 16 queries