Hi all,
I am trying to return a particular EDATE - either 5 months or 7 months after the 'start date' in the reference cell - depending on if the start date begins with August or March.
My desired scenario: If 'start date' begins with August (8), return value 7 months later. If 'start date' begins with March (3), return value for 5 months later.
The following formula was my best guess:
=IF(LEFT(D27,1)=8,EDATE(D27,7),EDATE(D27,5))
The issue with this is that the value returned when only using the LEFT function is 4, because this is the date when formatted as text instead of short date. This can be formatted into a date, but I do not think you can do that when it is used within another function. Either way, I am only using the first number as a reference from the 'start date,' so it would return a date from the incorrect year. I will attach a photo.
Any ideas on how to do this correctly?
IF and EDATE .png
Bookmarks