psulions83
Board Regular
- Joined
- Nov 16, 2015
- Messages
- 126
Hi All,
I have been searching for a solution for this and have not found anything. There may be something out there and I didn't search for the correct thing.
The below formula stacks the two dates on Sheet 1.
=TEXT(IF(D6="Y",F6-60,"N/A"),"mm/dd/yyyy")&CHAR(10)&(IF(D6="Y",IF(OR(MONTH(F6)=1,MONTH(F6)=2,MONTH(F6)=3),"4/30/"&YEAR(F6),
IF(OR(MONTH(F6)=4,MONTH(F6)=5,MONTH(F6)=6),"7/31/"&YEAR(F6),
IF(OR(MONTH(F6)=7,MONTH(F6)=8,MONTH(F6)=9),"10/31/"&YEAR(F6),
IF(OR(MONTH(F6)=10,MONTH(F6)=11,MONTH(F6)=12),"1/31/"&YEAR(F6)+1)))),"N/A"))
Results on Sheet 1 -
05/02/2023
10/31/2023
On Sheet 2 I am looking that value up and it does not format them in the same manner that it does.
Results on Sheet 2 using the following formula - =VLOOKUP(A5,'Sheet 1'!A:Y,25,0)
Any help would be greatly appreciated.
I have been searching for a solution for this and have not found anything. There may be something out there and I didn't search for the correct thing.
The below formula stacks the two dates on Sheet 1.
=TEXT(IF(D6="Y",F6-60,"N/A"),"mm/dd/yyyy")&CHAR(10)&(IF(D6="Y",IF(OR(MONTH(F6)=1,MONTH(F6)=2,MONTH(F6)=3),"4/30/"&YEAR(F6),
IF(OR(MONTH(F6)=4,MONTH(F6)=5,MONTH(F6)=6),"7/31/"&YEAR(F6),
IF(OR(MONTH(F6)=7,MONTH(F6)=8,MONTH(F6)=9),"10/31/"&YEAR(F6),
IF(OR(MONTH(F6)=10,MONTH(F6)=11,MONTH(F6)=12),"1/31/"&YEAR(F6)+1)))),"N/A"))
Results on Sheet 1 -
05/02/2023
10/31/2023
On Sheet 2 I am looking that value up and it does not format them in the same manner that it does.
Results on Sheet 2 using the following formula - =VLOOKUP(A5,'Sheet 1'!A:Y,25,0)
Any help would be greatly appreciated.