sameeracma
New Member
- Joined
- Jul 2, 2009
- Messages
- 7
Hi
this is urgent(part of a assignment)
I need an Excel formula which will take the month/day from one column plus the year from another column and combine these to
make a date in a third column. Then the formula will need to check if the new date in the third column is an odd year. If yes, then if the odd year date is less than the current date, change the date to the nearest odd year which has not occurred
yet. Also, the formula will need to do the same thing for dates in an even year.
I created a formula which combines the month/day into a new date in the third column but am missing the logic for the comparison of odd/even years.
i need the month/day from column B and the year from column F. The new combined date should appear in column I. I wrote a formula which does some of the work in column I but it's incomplete.
pls try to fix this up
<table style="border-collapse: collapse; width: 827pt;" width="1101" border="0" cellpadding="0" cellspacing="0"><col style="width: 158pt;" width="210"> <col style="width: 75pt;" width="100"> <col style="width: 79pt;" width="105"> <col style="width: 64pt;" width="85"> <col style="width: 62pt;" width="83"> <col style="width: 77pt;" width="102"> <col style="width: 75pt;" width="100"> <col style="width: 66pt;" width="88"> <col style="width: 88pt;" width="117"> <col style="width: 83pt;" width="111"> <tbody><tr style="height: 30pt;" height="40"> <td class="xl65" style="height: 30pt; width: 158pt;" width="210" height="40">Attorney Name</td> <td class="xl66" style="border-left: medium none; width: 75pt;" width="100">Birth
Date</td> <td class="xl67" style="border-left: medium none; width: 79pt;" width="105">DOB
Month</td> <td class="xl68" style="border-left: medium none; width: 64pt;" width="85">MCLE
Group</td> <td class="xl68" style="border-left: medium none; width: 62pt;" width="83">Bar
Number</td> <td class="xl69" style="border-left: medium none; width: 77pt;" width="102">Admit Year</td> <td class="xl70" style="border-left: medium none; width: 75pt;" width="100">Admit
Month</td> <td class="xl71" style="border-left: medium none; width: 66pt;" width="88">Odd/Even
Admit Year</td> <td class="xl71" style="border-left: medium none; width: 88pt;" width="117"> Compliance
Date</td> <td class="xl72" style="border-left: medium none; width: 83pt;" width="111">Compliance
Month</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl73" style="border-top: medium none; height: 12.75pt;" height="17">Ademola, Yomi (LO)</td> <td class="xl74" style="border-top: medium none; border-left: medium none;">03/12/1980</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">3-March</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">NY1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">4401832</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">04/18/2006</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">4-April</td> <td class="xl78" style="border-top: medium none; border-left: medium none;">Even</td> <td class="xl74" style="border-top: medium none; border-left: medium none;">3/12/2010</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">3-March</td> </tr> </tbody></table>
Formula=MONTH(B1)&"/"&DAY(B1)&"/"&IF(MOD(YEAR(F1),2)=0,IF(YEAR(F1)<TODAY(),(YEAR(TODAY())-YEAR(F1))+YEAR(F1)+1,),IF(YEAR(F169)<TODAY(),(YEAR(TODAY())-YEAR(F1))+YEAR(F1)+2,))<today(),(year(today())-year(f1))+year(f1)+1,),if(year><today(),(year(today())-year(f1))+year(f1)+2,))></today(),(year(today())-year(f1))+year(f1)+2,))></today(),(year(today())-year(f1))+year(f1)+1,),if(year>
this is urgent(part of a assignment)
I need an Excel formula which will take the month/day from one column plus the year from another column and combine these to
make a date in a third column. Then the formula will need to check if the new date in the third column is an odd year. If yes, then if the odd year date is less than the current date, change the date to the nearest odd year which has not occurred
yet. Also, the formula will need to do the same thing for dates in an even year.
I created a formula which combines the month/day into a new date in the third column but am missing the logic for the comparison of odd/even years.
i need the month/day from column B and the year from column F. The new combined date should appear in column I. I wrote a formula which does some of the work in column I but it's incomplete.
pls try to fix this up
<table style="border-collapse: collapse; width: 827pt;" width="1101" border="0" cellpadding="0" cellspacing="0"><col style="width: 158pt;" width="210"> <col style="width: 75pt;" width="100"> <col style="width: 79pt;" width="105"> <col style="width: 64pt;" width="85"> <col style="width: 62pt;" width="83"> <col style="width: 77pt;" width="102"> <col style="width: 75pt;" width="100"> <col style="width: 66pt;" width="88"> <col style="width: 88pt;" width="117"> <col style="width: 83pt;" width="111"> <tbody><tr style="height: 30pt;" height="40"> <td class="xl65" style="height: 30pt; width: 158pt;" width="210" height="40">Attorney Name</td> <td class="xl66" style="border-left: medium none; width: 75pt;" width="100">Birth
Date</td> <td class="xl67" style="border-left: medium none; width: 79pt;" width="105">DOB
Month</td> <td class="xl68" style="border-left: medium none; width: 64pt;" width="85">MCLE
Group</td> <td class="xl68" style="border-left: medium none; width: 62pt;" width="83">Bar
Number</td> <td class="xl69" style="border-left: medium none; width: 77pt;" width="102">Admit Year</td> <td class="xl70" style="border-left: medium none; width: 75pt;" width="100">Admit
Month</td> <td class="xl71" style="border-left: medium none; width: 66pt;" width="88">Odd/Even
Admit Year</td> <td class="xl71" style="border-left: medium none; width: 88pt;" width="117"> Compliance
Date</td> <td class="xl72" style="border-left: medium none; width: 83pt;" width="111">Compliance
Month</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl73" style="border-top: medium none; height: 12.75pt;" height="17">Ademola, Yomi (LO)</td> <td class="xl74" style="border-top: medium none; border-left: medium none;">03/12/1980</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">3-March</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">NY1</td> <td class="xl75" style="border-top: medium none; border-left: medium none;">4401832</td> <td class="xl76" style="border-top: medium none; border-left: medium none;">04/18/2006</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">4-April</td> <td class="xl78" style="border-top: medium none; border-left: medium none;">Even</td> <td class="xl74" style="border-top: medium none; border-left: medium none;">3/12/2010</td> <td class="xl77" style="border-top: medium none; border-left: medium none;">3-March</td> </tr> </tbody></table>
Formula=MONTH(B1)&"/"&DAY(B1)&"/"&IF(MOD(YEAR(F1),2)=0,IF(YEAR(F1)<TODAY(),(YEAR(TODAY())-YEAR(F1))+YEAR(F1)+1,),IF(YEAR(F169)<TODAY(),(YEAR(TODAY())-YEAR(F1))+YEAR(F1)+2,))<today(),(year(today())-year(f1))+year(f1)+1,),if(year><today(),(year(today())-year(f1))+year(f1)+2,))></today(),(year(today())-year(f1))+year(f1)+2,))></today(),(year(today())-year(f1))+year(f1)+1,),if(year>
Last edited: