How to calculate no of days between dates

Closed
Trapti - Mar 23, 2016 at 02:08 AM
Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 - Mar 24, 2016 at 11:35 AM
Hello,

How to calculate no of days between one constant date not written in excel sheet i.e. 31-03-2016 and other dates which is written in excel sheet in one of the column. please tell me if any one knows it, it is very challenging one.

1 reply

Mazzaropi Posts 1967 Registration date Monday August 16, 2010 Status Contributor Last seen October 3, 2022 146
Mar 24, 2016 at 11:35 AM
Trapti, good morning.

Try to use:
=DATEDIF(DATEVALUE("31/03/2016"), A1, "D")

Please, tell us if it worked for you.

Is it what you want?
I hope it helps.
0