Calculating the number of days between a set date and today

[broncos347]

I trying to work out what formula i should use to determine the number of days between a set date and the current date.

Can anyone help.

 

[barry houdini]

If your set date is in A1

=ABS(A1-Today())

 

[NBVC]

=Datedif(A1,today(),"d") or Datedif(Today(),A1,"d") depending on which date is later.

 

[nbrcrunch]

In Excel's help system, search for functions. From there navigate to Date functions.

You are probably looking for the DATEDIFF function.

 

[NBVC]

In Excel's help system, search for functions. From there navigate to Date functions.

You are probably looking for the DATEDIFF function.

nbrcrunch, I don't think there is any help files in the Excel Help for the DATEDIF function. It is one of those functions that used to be used more often I guess, and for some reason Excel kept it in their later versions available but without help files. I am not sure exactly of the history

 

[broncos347]

Thanks I used the ABS formula and it works.

Just looking at the results I have got, is there anyway to add another part to the formula so that if a cell (further along the spreadsheet, say E1) has a date in it then this cell (A1) reports a zero.

 

[barry houdini]

ABS is only necessary if you won't be sure whether A1 is greater than TODAY() or not, if you always know which is greater (or if you don't care and don't mind getting a negative result), e.g. if A1 is always in the future, then you could just use

=A1-TODAY()

If E1 either has a date or is blank then try

=(A1-TODAY())*(E1="")