<div>
you can use this:<br />
<br />
DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear])<br />
<br />
Example:<br />
DateDiff (&quot;yyyy&quot;, #15/10/1998#, #22/11/2003#) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;would return 5<br />
DateDiff (&quot;m&quot;, #15/10/2003#, #22/11/2003#) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;would return 1<br />
DateDiff (&quot;d&quot;, #15/10/2003#, #22/11/2003#) &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;would return 38
</div>


you can use this:

DateDiff ( interval, date1, date2, [firstdayofweek], [firstweekofyear])

Example:
DateDiff ("yyyy", #15/10/1998#, #22/11/2003#)       would return 5
DateDiff ("m", #15/10/2003#, #22/11/2003#)       would return 1
DateDiff ("d", #15/10/2003#, #22/11/2003#)       would return 38

<div>
<div class="content wysiwyg-content">
I need to replicate the Excel DAYS360 in an Access function
</div>
</div>


I need to replicate the Excel DAYS360 in an Access function

DAYS360

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.