cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JMSNYC Regular Visitor
Regular Visitor

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 date should be November, 1, 2018. It seems that date subtraction works if year does not change.

 

Am I missing something ?

 

Thanks for your help.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Super User
Super User

Re: SUBSTRACT DATE ISSUES

Hi,

Does this work?

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

JMSNYC Regular Visitor
Regular Visitor

Re: SUBSTRACT DATE ISSUES

AWESOME !!! Thank you so Much.

View solution in original post

4 REPLIES 4
HotChilli New Contributor
New Contributor

Re: SUBSTRACT DATE ISSUES

Usually this is due to the end result of the dateadd operation not existing as a date in the model so that's my educated guess.

From documentation : The result table includes only dates that exist in the dates column

Super User
Super User

Re: SUBSTRACT DATE ISSUES

Hi,

Does this work?

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


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

View solution in original post

JMSNYC Regular Visitor
Regular Visitor

Re: SUBSTRACT DATE ISSUES

AWESOME !!! Thank you so Much.

View solution in original post

Super User
Super User

Re: SUBSTRACT DATE ISSUES

You are welcome.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 254 members 2,479 guests
Please welcome our newest community members: