Forum Discussion

JMSNYC's avatar
JMSNYC
Icon for Helper III rankHelper III
7 years ago
Solved

SUBSTRACT DATE ISSUES

Hi.   I need to subtract an integer number of months from an existing date (e.g., -6 month from April, 1 2019).   Issue is: I have a blank cell using DATEADD(Date(2019,04,01),-6,MONTH), because d...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    7 years ago

    Hi,

    Does this work?

    =EDATE(Date(2019,04,01),-6)

  • JMSNYC's avatar
    JMSNYC
    7 years ago

    AWESOME !!! Thank you so Much.

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
7 years ago

Hi,

Does this work?

=EDATE(Date(2019,04,01),-6)

JMSNYC's avatar
JMSNYC
Icon for Helper III rankHelper III
7 years ago

AWESOME !!! Thank you so Much.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    7 years ago

    You are welcome.