Forum Discussion

Victormar's avatar
Victormar
Icon for Helper V rankHelper V
2 years ago
Solved

Year calculation for leap years

Hello, community   I have a situation where I have contracted dates for vehicles, and I need to calculate the renovation date, which is after 6 months and after one year. The thing is that I have s...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi Victormar 

     

    Instead of adding a 1 to the year or 6 to the month, why not just use EDATE?  EDATE ( DATE (2024, 3, 1), 18 ) is DATE (2025, 9, 1) which is 18 months after the original date. Or if you want the date 18 months prior, just use -18.
    March 1, 2024 becomes

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi Victormar 

 

Instead of adding a 1 to the year or 6 to the month, why not just use EDATE?  EDATE ( DATE (2024, 3, 1), 18 ) is DATE (2025, 9, 1) which is 18 months after the original date. Or if you want the date 18 months prior, just use -18.
March 1, 2024 becomes