Google Sheets - Number of days since the last date a range of cellsranges and conditional formatting on google spreadsheetGoogle Sheets SUMIFS does not worki need to calculate a time difference in google sheetsreset count if cell in a range is blank in googlesheetsGoogle Sheets email once based on cell valuesBest way to automatically format timestamps to just include date(Google Sheets)How to use IMPORTRANGE and SUBSTITUTE in same formula for Google SheetsHighlight Source Data Cell When Selecting Query Result CellReference cell to another sheet cell which has array formula?Google Sheets - After Cell A37 is populated, need to auto jump to cell E9
Bob has never been a M before
Diode in opposite direction?
How do I repair my stair bannister?
What is this type of notehead called?
Freedom of speech and where it applies
Did US corporations pay demonstrators in the German demonstrations against article 13?
MAXDOP Settings for SQL Server 2014
Visiting the UK as unmarried couple
Can somebody explain Brexit in a few child-proof sentences?
Why we can't differentiate a polynomial equation as many times as we wish?
Is it possible to have a strip of cold climate in the middle of a planet?
What is the grammatical term for “‑ed” words like these?
How can "mimic phobia" be cured or prevented?
THT: What is a squared annular “ring”?
Create all possible words using a set or letters
Will adding a BY-SA image to a blog post make the entire post BY-SA?
What linear sensor for a keyboard?
Count the occurrence of each unique word in the file
Longest common substring in linear time
Why does Async/Await work properly when the loop is inside the async function and not the other way around?
How to decide convergence of Integrals
A social experiment. What is the worst that can happen?
Can a significant change in incentives void an employment contract?
If a character with the Alert feat rolls a crit fail on their Perception check, are they surprised?
Google Sheets - Number of days since the last date a range of cells
ranges and conditional formatting on google spreadsheetGoogle Sheets SUMIFS does not worki need to calculate a time difference in google sheetsreset count if cell in a range is blank in googlesheetsGoogle Sheets email once based on cell valuesBest way to automatically format timestamps to just include date(Google Sheets)How to use IMPORTRANGE and SUBSTITUTE in same formula for Google SheetsHighlight Source Data Cell When Selecting Query Result CellReference cell to another sheet cell which has array formula?Google Sheets - After Cell A37 is populated, need to auto jump to cell E9
I know how to return the number of days from a specific date, it requires to input a cell. The thing is, I have an ever-growing list of emails to be sent (in new columns), so the date needs to be updated with the new column.
If 2 columns have 2 dates in, can the formula be something like =minus(TODAY(), between B6 and D6)?
Use the spreadsheet link to test please - https://docs.google.com/spreadsheets/d/1dQNMMiSvfGNSj5mJ4Uu8kbEATPSS35_Cd-wbbfrrGPM/edit?usp=sharing
google-sheets google-sheets-formula
edited Mar 21 at 13:50
player0
6,25041232
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
add a comment |
I know how to return the number of days from a specific date, it requires to input a cell. The thing is, I have an ever-growing list of emails to be sent (in new columns), so the date needs to be updated with the new column.
If 2 columns have 2 dates in, can the formula be something like =minus(TODAY(), between B6 and D6)?
Use the spreadsheet link to test please - https://docs.google.com/spreadsheets/d/1dQNMMiSvfGNSj5mJ4Uu8kbEATPSS35_Cd-wbbfrrGPM/edit?usp=sharing
google-sheets google-sheets-formula
edited Mar 21 at 13:50
player0
6,25041232
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
add a comment |
I know how to return the number of days from a specific date, it requires to input a cell. The thing is, I have an ever-growing list of emails to be sent (in new columns), so the date needs to be updated with the new column.
If 2 columns have 2 dates in, can the formula be something like =minus(TODAY(), between B6 and D6)?
Use the spreadsheet link to test please - https://docs.google.com/spreadsheets/d/1dQNMMiSvfGNSj5mJ4Uu8kbEATPSS35_Cd-wbbfrrGPM/edit?usp=sharing
google-sheets google-sheets-formula
edited Mar 21 at 13:50
player0
6,25041232
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
I know how to return the number of days from a specific date, it requires to input a cell. The thing is, I have an ever-growing list of emails to be sent (in new columns), so the date needs to be updated with the new column.
If 2 columns have 2 dates in, can the formula be something like =minus(TODAY(), between B6 and D6)?
Use the spreadsheet link to test please - https://docs.google.com/spreadsheets/d/1dQNMMiSvfGNSj5mJ4Uu8kbEATPSS35_Cd-wbbfrrGPM/edit?usp=sharing
google-sheets google-sheets-formula
google-sheets google-sheets-formula
edited Mar 21 at 13:50
player0
6,25041232
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
edited Mar 21 at 13:50
player0
6,25041232
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
edited Mar 21 at 13:50
player0
6,25041232
edited Mar 21 at 13:50
player0
6,25041232
edited Mar 21 at 13:50
player0
6,25041232
6,25041232
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
asked Mar 21 at 13:43
Harry NormanHarry Norman
305
305
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
try like this:
=DAYS(TODAY(), D6)
or perhaps like this:
=DAYS(TODAY(), MAX(B6:D6))
answered Mar 21 at 13:59
player0player0
6,25041232
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55281833%2fgoogle-sheets-number-of-days-since-the-last-date-a-range-of-cells%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
try like this:
=DAYS(TODAY(), D6)
or perhaps like this:
=DAYS(TODAY(), MAX(B6:D6))
answered Mar 21 at 13:59
player0player0
6,25041232
add a comment |
try like this:
=DAYS(TODAY(), D6)
or perhaps like this:
=DAYS(TODAY(), MAX(B6:D6))
answered Mar 21 at 13:59
player0player0
6,25041232
add a comment |
try like this:
=DAYS(TODAY(), D6)
or perhaps like this:
=DAYS(TODAY(), MAX(B6:D6))
answered Mar 21 at 13:59
player0player0
6,25041232
try like this:
=DAYS(TODAY(), D6)
or perhaps like this:
=DAYS(TODAY(), MAX(B6:D6))
answered Mar 21 at 13:59
player0player0
6,25041232
answered Mar 21 at 13:59
player0player0
6,25041232
answered Mar 21 at 13:59
player0player0
6,25041232
answered Mar 21 at 13:59
player0player0
6,25041232
6,25041232
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55281833%2fgoogle-sheets-number-of-days-since-the-last-date-a-range-of-cells%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
