Answered step by step
Verified Expert Solution
Question
1 Approved Answer
In A3 The date is 2025, Fix this formula so it does not produce a 1905 year and keeps the 2025 year =IF(OR(RIGHT(A3,1)=8,RIGHT(A3,1)=9),DATE(A3,1,1),IF(MID(TEXT(DATE(A3,RIGHT(A3)+5,25),dddd),2,1)=MID(TEXT(DATE(A3,RIGHT(A3)+5,25),mmmm),2,1),DATE(A3,1,1)+IF(WEEKDAY(DATE(A3,1,1))=1,0,7-WEEKDAY(DATE(A3,1,1))+1)+21,IF(SUM(INT(MID(TEXT(A3,mmdd),ROW(INDIRECT(1:&LEN(TEXT(A3,mmdd)))),1)))=15,DATE(YEAR(A3),2,27),DATE(A3,MOD(RIGHT(A3,1)+5,10),1))))
In A3 The date is 2025, Fix this formula so it does not produce a 1905 year and keeps the 2025 year =IF(OR(RIGHT(A3,1)="8",RIGHT(A3,1)="9"),DATE(A3,1,1),IF(MID(TEXT(DATE(A3,RIGHT(A3)+5,25),"dddd"),2,1)=MID(TEXT(DATE(A3,RIGHT(A3)+5,25),"mmmm"),2,1),DATE(A3,1,1)+IF(WEEKDAY(DATE(A3,1,1))=1,0,7-WEEKDAY(DATE(A3,1,1))+1)+21,IF(SUM(INT(MID(TEXT(A3,"mmdd"),ROW(INDIRECT("1:"&LEN(TEXT(A3,"mmdd")))),1)))=15,DATE(YEAR(A3),2,27),DATE(A3,MOD(RIGHT(A3,1)+5,10),1))))
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started