Subtract Start Date from End Date

[sjh31182]

Example- How to do you display # of days between 6/11/2011 and 6/11/2012 and use only the month and day data (Year is not relevant). So If I used 6/11/99 I would get the same answer of days in between as 6/11/2011.

This is the formula I am using now, which gives me the data with the year information.

=IF(AND(A4<>"",A5<>""),DATEDIF(A4,A5,"0"),"")

A4 is start date
A5 is end date

[Pepe Le Mokko]

Wrong answer

[dilipandey]

Hi sjh31182,


You can use the below formula:-

=DATE(1,MONTH(A5),DAY(A5))-DATE(1,MONTH(A4),DAY(A4))
diff betwen date n ignore year.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[Paul]

If you're simply looking for a count of days between dates excluding the year variability, then this should work:

=DATEDIF(A4,A5,"yd")