Subtracting dates

[etrotter]

Hello!

How would I go about subtracting these two dates? I would like to include weekend days.

[vishsaggi · Accepted solution]

So what is happening when you try like

= Received_Date - Promised_Date

[its_anandrjs]

Try with

=Interval(  Received_Date - Promised_Date,'D hh:mm' )

Regards

Anand

[suryaa30]

=Ceil(Interval(Date#([Field2], 'MM/DD/YYYY') - Date#([Field1], 'MM/DD/YYYY'), 'DD' ))

[etrotter]

I had to change the format in the back end but that worked!

[vishsaggi]

Glad. Can you close the thread marking correct/helpful responses accordingly.