Date and Days in Excel

dear All,

i have a cell in excel sheet and i need to use it to count the days remaining for this date in another cell compare with the date of the computer (today), example:

25/March/2015 ... remaining days .... 6 days

Please help
RhalaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ProfessorJimJamMicrosoft Excel ExpertCommented:
put in A1 3/25/2015 and put in B1  =Today()  and then put in C1  =A1-B1
0
RhalaAuthor Commented:
I tried this but it didn't work

also,  i don't need to include B1 cell, i have many different cells in the sheet which i need to count the days from, is there a way??
0
Rodney EndrigaData AnalystCommented:
Try this formula in a cell in your Worksheet:

=ABS(DAYS360(A1,NOW()))

You will need to adjust the 'A1' reference to the cell where your date value exist. This should give you the number of days from TODAY'S computer date.
0
JavaScript Best Practices

Save hours in development time and avoid common mistakes by learning the best practices to use for JavaScript.

barry houdiniCommented:
I wouldn't use DAYS360 function to count days - as the name implies that function assumes a 360 day year (and 30 day month) so it can give incorrect counts when the dates cross different months.

Prof JimJam has given you the correct method, I think - just a simple subtraction. You say that didn't work, in what way? Make sure you format the result cell as number or general, e.g. with future date in A2 use this formula in B2

=A2-TODAY()

format B2 as general

Will the dates all be in the future? What result do you want if they are in the past?

regards, barry
0
RhalaAuthor Commented:
Hi,

i tried both and it's not working, kindly check the below:
1
2
3
0
barry houdiniCommented:
If you get #VALUE! error that probably means that your "dates" are not recognised as dates by Excel - do your regional settings demand that the date is entered as m/d/yyyy? If you enter B5 as 9/21/2015 does that work?

Note that 29/2/2015 in B6 isn't a valid date whatever your regional settings, February 2015 only has 28 days

regards, barry
0
RhalaAuthor Commented:
didn't work, kindly check the below:
Capture.PNG
0
ProfessorJimJamMicrosoft Excel ExpertCommented:
Please read carefully what has Barry wrote .
Your region setting is not day month year but
It is month then day and then year

For example if you want to put 25 March 2015
You must enter in cell 3/25/2015
0
barry houdiniCommented:
....but in this latest example I5 looks like a valid date

Your formula is working but you need to re-format J5 - format as general and you should see the result of 18. This demonstrates what I said about DAYS360 function - it won't give you the correct number of days when you cross months - 23rd March until 11th April is 19 days - DAYS360 gives you the wrong result because it treats March as a 30 day month.

Just use the simple subtraction in J5 as suggested by ProfessorJimJam

=I5-TODAY()

and make sure you format J5 as general or number

regards, barry
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.