Date and Days in Excel

put in A1 3/25/2015 and put in B1  =Today()  and then put in C1  =A1-B1

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??

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.

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

Hi,

i tried both and it's not working, kindly check the below:

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

didn't work, kindly check the below:

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