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?
 
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
 
ProfessorJimJamCommented:
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
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
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
 
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
 
ProfessorJimJamCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.