Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: Display Yesterday's Date In Cell

  1. #1
    Join Date
    13th July 2007
    Posts
    1

    Display Yesterday's Date In Cell

    I have a spreadsheet which i have to update daily with the previous days numbers.
    I would like for 'yesterdays' date to be entered automatically.

    I'm sure there is a way but i don't know how or haven't found the answer yet?

    can someone help.

    thanks for the opportunity to post.


    dave

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    18th February 2004
    Location
    Florida
    Posts
    181

    Re: Date

    Hello,
    Put:
    =Today()-1 in desired cell.
    HTH
    JL

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    8th December 2006
    Location
    New Zealand
    Posts
    3,914

    Re: Date

    daj0kker,

    POOR THREAD TITLE Please read THIS PAGE IN FULL

Thread Information

Users Browsing this Thread

There are currently 3 users browsing this thread. (0 members and 3 guests)

Possible Answers

  1. Cell display after the date expire
    By wilsontracy in forum EXCEL HELP
    Replies: 7
    Last Post: February 16th, 2006, 18:12
  2. Cell display after the date expire
    By wilsontracy in forum EXCEL HELP
    Replies: 1
    Last Post: February 16th, 2006, 13:23
  3. Yesterday's Date
    By Jonny1409 in forum EXCEL HELP
    Replies: 20
    Last Post: August 21st, 2005, 09:40
  4. Display today's date in a cell
    By eddie57 in forum EXCEL HELP
    Replies: 2
    Last Post: January 21st, 2005, 03:57
  5. "Save As" w/yesterday's Date in Filename
    By Rubix³ in forum EXCEL HELP
    Replies: 5
    Last Post: October 22nd, 2004, 05:41

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
  •  
porno