Sometimes, you might need full records for the previous 6 months. But when exactly was that?

Here's how to find out exactly which date was 6 months ago.

1. Open Excel, Google Sheets, LibreOffice Calc, or GNUmeric

2. edit the formula for cell A1 by typing the following formula: =EDATE(TODAY(), -6)

3. Finally, format that cell as a date.

For a spreadsheet tool already built to do this for you, just visit this link below (shorturl is safe, leads to a Google sheet with proper validation and protection to prevent vandalism):

https://is.gd/Bj3Dhm