How to calculate no of days between dates

Closed

Trapti - Mar 23, 2016 at 02:08 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - 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.

How to calculate no of days between dates
Skype last seen days ago - Guide
How to calculate position in excel - Excel Forum
How to calculate fuel surcharge - Excel Forum
How to calculate vat in excel - Guide
How to calculate percentage of marks of 6 subjects - Excel Forum

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
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.

Similar discussions

encryption message several time in chat

How to calculate positions (1st,2nd,3rd...) in Excel

Can’t access settings for a few days lock out

IF statements with dates and criteria

using web browser page loads but screen blank

Similar discussions

Subscribe To Our Newsletter!