Forum Discussion

rachelh114's avatar
rachelh114
Copper Contributor
Feb 11, 2025

EDATE a cell until end of that month

Hello All, 

I am trying to create a master list for my company's calibrated tooling. 

Is it possible to use a formula or EDATE in a cell for 12 months but until the end of the month and not the date in the reference cell? 

For example: 01/09/2025 until 01/31/2026 instead of until 01/09/2026

 

Thank you in advance for any help. 

1 Reply

  • m_tarler's avatar
    m_tarler
    Bronze Contributor

    Try:

    =EOMONTH(A1, 12)

    where A1 is the cell you want to reference

Resources