Programming

Programming questions? Ask a programmer for answers ASAP

Ask a Computer Expert,
Get an Answer ASAP!

This answer was rated:

I want to calculate numbers of days from a start date to…

I want to calculate...

I want to calculate numbers of days from a start date to today or when I open in a week from now to that date. is it possible?

Technician's Assistant: Is there a specific language you're coding in?

No just looking for excel formula that will do it

Technician's Assistant: When did you last update Excel?

Don't remember but my version is on the new side

Show More
Show Less
Ask Your Own Programming Question
Answered in 8 minutes by:
7/30/2017
R Hefner
R Hefner, Computer Engineer and Instructor
Category: Programming
Satisfied Customers: 104
Experience: Solution Engineer
Verified

Hello. My name is***** to JustAnswer. I'm reviewing your question now, and will post back with your reply momentarily.

Ask Your Own Programming Question

Do you want to do this in excel or another program

Ask Your Own Programming Question

If you are using excel - I can give you instructions

Ask Your Own Programming Question

Here is the function"

Start Date 4/30/1968 17987

End Date 7/29/2017

The function for C1 is =DATEDIF(B1,B2,"d") The key here is the "d" for days, and you can use "m" for months, "y" for years etc

Ask Your Own Programming Question

If you have any questions, please let me know otherwise if you can take a minute and use the rating system at the top of the screen to rate our session as 5 stars and press Submit.
Thank you for using justanswers and have a great day.

Richard H

Ask Your Own Programming Question
Customer reply replied 11 months ago
R. Hefner - let say i put start day in a1 7-30-1988 at B1 i want to get days on market every time i open the file. calculated to today (without writing in A2 today's date. can it be done? - second i need to finish the payment as i called the credit card company to stop it as i did not get anything other than pay $5 to start and before i got an answer to pay $60 more. as you see the formula you gave me does not work. if you think phone call will work please call me at(###) ###-####thanks.

Answers to questions:

1. What do you means dates on market, do mean every day or just weekdays?

2. There is no way to have excel auto populate todays date, you have to add it

3. Did you format the cells to make them dates before adding the formula, if not the equation will not work

4. What time PST is good for you to help you through the formula

Ask Your Own Programming Question
Customer reply replied 11 months ago
if you are talking about a good time today - any time will work. thank you

I will call you at 7 pm your time EST. I would also like to conduct a desktop share and will send you information to desktop share closer to the time. Can we confirm 7 PM EST

R Hefner
R Hefner, Computer Engineer and Instructor
Category: Programming
Satisfied Customers: 104
Experience: Solution Engineer
Verified
R Hefner and 87 other Programming Specialists are ready to help you
Ask your own question now
Customer reply replied 11 months ago
if needed there no problem to do it call at 7:00PM to(###) ###-####

http://www.justanswer.com/remotedesktop/join.aspx?Session=aacb9fae-526e-41da-9f7b-1e2c4d5a1b04

Please go to this link and follow the instructions

Ask Your Own Programming Question

http://www.justanswer.com/remotedesktop/join.aspx?Session=c578fefb-77e3-4bb5-8824-9600ad3bad18

Please go to this link

Ask Your Own Programming Question

https://secure.logmein.com/i?l=en&c=01_j4z797ikk0gitpf4oqa2qp47yike6ixdlatkt

Ask Your Own Programming Question

https://tdmeet.webex.com/tdmeet-en/e.php?MTID=m64d8efe82668fc43a4e47c63dfa3ca71

Please go to this link

Ask Your Own Programming Question

If you have any questions, please let me know otherwise if you can take a minute and use the rating system at the top of the screen to rate our session as 5 stars and press Submit.
Thank you for using justanswers and have a great day.

Richard H

Ask Your Own Programming Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a programmerLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask R Hefner Your Own Question
R Hefner
R Hefner
R Hefner, Computer Engineer and Instructor
Category: Programming
Satisfied Customers: 104
104 Satisfied Customers
Experience: Solution Engineer

R Hefner is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

ATLPROG

ATLPROG

Computer Software Engineer

7,677 satisfied customers

MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

LogicPro

LogicPro

Computer Software Engineer

7,175 satisfied customers

Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

unvadim

unvadim

Computer Software Engineer

1,168 satisfied customers

Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

lifesaver

lifesaver

Computer Software Engineer

950 satisfied customers

Several years of intensive programming and application development experience in various platforms.

ehabtutor

ehabtutor

Computer Software Engineer

936 satisfied customers

Bachelor of computer science, 5+ years experience in software development, software company owner

TheDoctor

TheDoctor

Software Engineer

893 satisfied customers

M.S. in Internet Information Systems

The-PC-Guy

The-PC-Guy

Software Engineer

848 satisfied customers

Extensive Knowledge in PHP, MYSQL, CSS & Javascript

< Previous | Next >

Related Programming Questions
I need excel calculated Formulas to capture my data, Excel
Hi, I need excel calculated Formulas to capture my data … read more
Bruce Wilner
Bruce Wilner
Master of Engineering
29 satisfied customers
Need a formula which looks up a value for today from a cell
need a formula which looks up a value for today from a cell with a value which changes daily and returns the value for today but tomorrow the value remains unchanged in that cell and has now moved to … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
I am wanting to calculate both: the difference between two
I am wanting to calculate both: the difference between two dates (lets say "A" and "B") and be able to enter a number of days and have that be added to the original date (A): So If I enter a date in c… read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
Heres a simple excel formula: = (E4*15) E4 represents
Here's a simple excel formula: = (E4*15) E4 represents PTO Accrual Rate 15 represent number of weeks of accrued hours I want to create a Macro where the number of weeks will automatically change when … read more
The-PC-Guy
The-PC-Guy
Software Engineer
Bachelor's Degree
848 satisfied customers
Trying to write a formula in excel to have a cell count 60
Trying to write a formula in excel to have a cell count 60 days forward automatically to the cell to the right based on whatever date I put in the cell to the left. The cell that has the 60 day formul… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I am trying to limit the time that an excel spreadsheet can
I am trying to limit the time that an excel spreadsheet can be accessed, without using a macro. Is there anyway to lock a calculated cell value based on a condition in the spreadsheet.… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I Have a cell that calculates minutes into days but i need
I Have a cell that calculates minutes into days but i need this cell to omit weekends if a timed projection goes more than 7 days. How do i omit weekends?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Canadians (Snow Birds) need to keep tab on number of days they stay in the last 36 months,
Canadians (Snow Birds) need to keep tab on number of days they stay in the last 36 months, calculates as the total of 1/3 of month 25 to 36, 2/3 of month 13 to 24 and all days in month 1 to 12. Is it … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
hi, i am using the following formula weeknum(A2,1) A2 TODAY().
hi, i am using the following formula =weeknum(A2,1) A2=TODAY(). i am currently getting week 40 as a returned result. what i am trying to get now is the date range that wk 40 equals to. any sugestions?… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Two columns filled with dates start finish - row across
Two columns filled with dates "start" "finish" - row across top of sheet with period ending dates. Problem to identify which period date the start/finish dates span - once that is done must calculate … read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I would like to make excel formula that calculates a number
I would like to make excel formula that calculates a number that doubles every 28 days. I want to enter subtaction to that total which then will double again in 28 days. I also want to have a cell for… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I want to calculate daily, weekly and biweekly hours worked
I want to calculate daily, weekly and biweekly hours worked for my employees. How can I do this in excel. I know very little so please just give me specific formulas. thanks… read more
John The Geek
John The Geek
Senior Software Developer
Bachelor\u0027s Degree
65 satisfied customers
Could you please give me a formuls for excell 2007 that will
Could you please give me a formuls for excell 2007 that will enable me to get a progressive date if I enter a starting date 11.8.96 and a number of weeks say 4. the weeks will change over time and so … read more
C.Martin
C.Martin
IT Consultant
Bachelor's Degree
453 satisfied customers
Using excel, Id like to enter a date in one cell, then the
Using excel, I'd like to enter a date in one cell, then the number 30 (as in business days) in the next cell. In the third cell, I want a formula that gives me a date that is 30 business days from the… read more
C.Martin
C.Martin
IT Consultant
Bachelor's Degree
453 satisfied customers
I want to start with a specific date, add 1 year, then take
I want to start with a specific date, add 1 year, then take that result and advance the date to january 1 of the following year. EXAMPLE: Start Date 04/15/07 Add 1 year 04/15/08 Then advance date to 0… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Hello John D, I have a new question for you . . . in Excel,
Hello John D, I have a new question for you . . . in Excel, I am using the following formula to automatically calculate total sales of a product over the last 12 months =SUMPRODUCT(--($AB$4:$BU$4>=… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
I need to caculate how many weeks redundancy payments would
I need to caculate how many weeks redundancy payments would be due for a lot of employees based on the following: For each compete year of service , up to a maximum of 20 years, employees are entitled… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
im trying to make what I call a Daily Expiration Ticker for
im trying to make what I call a "Daily Expiration Ticker" for my military training spreadsheet, it's working with excel. In one cell I have today's date, next to it i have an expiration date that's in… read more
John D
John D
Bachelor Degree in Engineering
342 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x