Ingenium Schools Support Desk

1. Open the downloaded file from FS, then open it using Google Sheets. Look for Assigned On, Acquisition Date, Warranty Date, and Last Audit Date. 

2. Remove the:00 at the end of all dates.

3. Insert one column on the right of the dates you are working on, then use this formula =LEFT(I2,LEN(I2)-3) if you want to remove the zeros for more than one date.

4. This should look like this. 

5. Copy the one you just created.

6. Then paste it with Values only.

7. Delete the one with the formula after you paste it. 

8. Download the spreadsheet and upload it on FS.

9. Upload it on FS.