Date to days

[banker123]

If I have a date in say column A (9/30/13) is there a way I can bring a value that (using todays date) tells me how many days it's been from 9/30/13 to 7/22/14?

[Special-K]

Just subtract them

=B1-A1

where A1 and B1 are dates will give you the number of days difference

[sweep]

Hi,

Try this:

=DATEDIF(A1,TODAY(),"d")

[Vikas_Gautam]

Try

=Today()-A1+1

if you wanna add the current day...

press Ctrl + shift + ~ to change the result in date format in number format..


Don't forget to click *

[banker123]

Great! Thanks.