Tjyylli

Are Wave equations equivalent to Maxwell equations in free space?

The past tense for the quoting particle って

How do you make a gun that shoots melee weapons and/or swords?

When to use the term transposed instead of modulation?

How does a sound wave propagate?

New invention compresses matter to produce energy? or other items? (Short Story)

Is this nominative case or accusative case?

Should I use HTTPS on a domain that will only be used for redirection?

The need of reserving one's ability in job interviews

Are healthy patients an appropriate control group?

What is the meaning of option 'by' in TikZ Intersections

Why can't we use freedom of speech and expression to incite people to rebel against government in India?

Custom javascript not working

Where do you go through passport control when transiting through another Schengen airport on your way out of the Schengen area?

An Undercover Army

Do natural melee weapons (from racial traits) trigger Improved Divine Smite?

Is there a math expression equivalent to the conditional ternary operator?

Was it really inappropriate to write a pull request for the company I interviewed with?

What can I do if someone tampers with my SSH public key?

Can a space-faring robot still function over a billion years?

Ultrafilters as a double dual

Is being socially reclusive okay for a graduate student?

How spaceships determine each other's mass in space?

newcommand: Using one parameter as the default for the other

Workday Count-Down Formula when cell has a value entered

Excel formula creationHow can I use COUNTIF and TODAY functions to identify work deadlines in multiple worksheets?IF Function and Time SubtractionExcel formula to count when value changes?Excel Equation: How to skip cell value if row header contains certain textIF formula in Excel to calculate various outputs, defined by days between 2 datesCalculate totals for items in drop down boxesExcel Sum Array from different cell valueDisplay certain selection based on cell value - scheduling in ExcelCell has text and number, but I need to count both

-1

I need to add a Workday Count Down to my project plan. As soon as the action has been completed (3 installs are done for the day) and I enter 3 in B14 I need my Total Work Days left (N1) to subtract 1 day to show the amount of the work days left to complete the project.

My problem is, it subtracts the amount of installs instead of just 1 day.

microsoft-excel worksheet-function

share|improve this question

edited 15 hours ago

Burgi

3,926102543

asked 20 hours ago

user1005411user1005411

1

New contributor

user1005411 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you provide some example data?
  
  – Burgi
  15 hours ago
  

  
  
  
  

add a comment | 

-1

I need to add a Workday Count Down to my project plan. As soon as the action has been completed (3 installs are done for the day) and I enter 3 in B14 I need my Total Work Days left (N1) to subtract 1 day to show the amount of the work days left to complete the project.

My problem is, it subtracts the amount of installs instead of just 1 day.

microsoft-excel worksheet-function

share|improve this question

edited 15 hours ago

Burgi

3,926102543

asked 20 hours ago

user1005411user1005411

1

New contributor

user1005411 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

• 
  
  
  

  
  

  
  
  
  
  
  

  
  
  Can you provide some example data?
  
  – Burgi
  15 hours ago
  

  
  
  
  

add a comment | 

I need to add a Workday Count Down to my project plan. As soon as the action has been completed (3 installs are done for the day) and I enter 3 in B14 I need my Total Work Days left (N1) to subtract 1 day to show the amount of the work days left to complete the project.

My problem is, it subtracts the amount of installs instead of just 1 day.

microsoft-excel worksheet-function

share|improve this question

edited 15 hours ago

Burgi

3,926102543

asked 20 hours ago

user1005411user1005411

1

New contributor

user1005411 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 15 hours ago

Burgi

3,926102543

asked 20 hours ago

user1005411user1005411

1

New contributor

user1005411 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this question

edited 15 hours ago

Burgi

3,926102543

asked 20 hours ago

user1005411user1005411

1

New contributor

user1005411 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 15 hours ago

Burgi

3,926102543

edited 15 hours ago

Burgi

3,926102543

asked 20 hours ago

user1005411user1005411

1

New contributor

user1005411 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

asked 20 hours ago

user1005411user1005411

1

1 Answer
1

active

oldest

votes

0

I don't really know how is it that you're doing it, but you could do an COUNTA(range), that counts cells that are not blank, and subtract it from the number of work days you have.

So it would be like: NumberOfWorkdays - COUNTA(range).

share|improve this answer

edited 15 hours ago

Burgi

3,926102543

answered 16 hours ago

Gabriel MarinelloGabriel Marinello

11

New contributor

Gabriel Marinello is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
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
});


}
});

user1005411 is a new contributor. Be nice, and check out our Code of Conduct.

draft saved

draft discarded

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

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1412091%2fworkday-count-down-formula-when-cell-has-a-value-entered%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

I don't really know how is it that you're doing it, but you could do an COUNTA(range), that counts cells that are not blank, and subtract it from the number of work days you have.

So it would be like: NumberOfWorkdays - COUNTA(range).

share|improve this answer

edited 15 hours ago

Burgi

3,926102543

answered 16 hours ago

Gabriel MarinelloGabriel Marinello

11

New contributor

Gabriel Marinello is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

0

I don't really know how is it that you're doing it, but you could do an COUNTA(range), that counts cells that are not blank, and subtract it from the number of work days you have.

So it would be like: NumberOfWorkdays - COUNTA(range).

share|improve this answer

edited 15 hours ago

Burgi

3,926102543

answered 16 hours ago

Gabriel MarinelloGabriel Marinello

11

New contributor

Gabriel Marinello is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

add a comment | 

I don't really know how is it that you're doing it, but you could do an COUNTA(range), that counts cells that are not blank, and subtract it from the number of work days you have.

So it would be like: NumberOfWorkdays - COUNTA(range).

share|improve this answer

edited 15 hours ago

Burgi

3,926102543

answered 16 hours ago

Gabriel MarinelloGabriel Marinello

11

New contributor

Gabriel Marinello is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

share|improve this answer

edited 15 hours ago

Burgi

3,926102543

answered 16 hours ago

Gabriel MarinelloGabriel Marinello

11

New contributor

Gabriel Marinello is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

edited 15 hours ago

Burgi

3,926102543

edited 15 hours ago

Burgi

3,926102543

answered 16 hours ago

Gabriel MarinelloGabriel Marinello

11

New contributor

Gabriel Marinello is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.

answered 16 hours ago

Gabriel MarinelloGabriel Marinello

11