Announcement

Collapse
No announcement yet.

Display Yesterday's Date In Cell

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    Re: Date

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

    Comment


    • #3
      Re: Date

      daj0kker,

      POOR THREAD TITLE Please read THIS PAGE IN FULL
      Reafidy

      Forum Rules | Anatomy Of A Good Thread Title | What Have You Tried So Far? | Are You A Cross Poster?

      Comment

      Working...
      X