ST Alpha - "ST Excel Help " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 158

ST Excel Help

Posted by znufrii Aug 11 '09, 08:33

I have a column with a series of dates, and want to add a column showing how many days ago that date is. Is there a formula to do this automatically without having to manually update a field with today's date every day I open the file?

Responses:

=DAYS360(A1,TODAY(),FALSE) -- nm - JaxSean Aug 11, 08:36
=today-cellref -- nm - Roger More Aug 11, 08:33 3
- thanks! -- nm - znufrii Aug 11, 08:34 2
  - sorry - this won't work. Correct instructions inside - Roger More Aug 11, 08:38 1
    - I figured it out - znufrii Aug 11, 08:39

Post a message top

ST Excel Help

Replies are disabled on threads older than 7 days.