Report export formula issue

Good day

I have created a report on SAGE which includes a formula to calculate the amount of days a position has been vacant, but when I export this report to excel the formula column just goes to all zero.  It seems that the formula is remove with the export.  I can export to PDF and the amount of days still shows correctly, it is only when I export to excel that this is changed.

If anyone could assist this will be appreciated