Purchase Solution

Incrementally increase a value in Excel by 1 every 24 hours

Not what you're looking for?

Ask Custom Question

How do you increase a value(cell) in Excel by "1" every 24 hours? I am trying to format an entire column (using "Conditional Formatting") so that all the cells(in that column) increase by 1 for every passing day. For example; Take "A1" as the number "30". How do I get it to read "31" after 12:01am elapses? And then so on, "32"..."33"... I want to have increments of 1 for every individual number in that entire column. So if I enter in "A2", "35", I would want it to read "36" the next day. Please help, I cannot figure this out.

Purchase this Solution

Solution Summary

The expert examines incremental increase values in Excel by 1 every 24 hours.

Solution Preview

Example of what to write in a cell:

Expression
TODAY() - DATEVALUE("2010/1/1") - 278
evaluates to 0 today (ON MY PC!), it will be 1 tomorrow, etc.

IMPORTANT:

(1) The format of the date as written by a string, "2010/1/1", is determined BY THE COMPUTER.
In this example it ...

Purchase this Solution


Free BrainMass Quizzes
Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.