Gohar Shahab
Active Member
- Joined
- May 17, 2006
- Messages
- 339
I have got following formula that gives me dates in the following format upto the year 2009-10, i want to add in this formula now 2010-11 which starts from 01.01.2010 to 31.12.2010, how to do that...or any other formula to handle it.
=IF(E131="","",YEAR(E131)-(MONTH(E131)<6)&"-"&RIGHT(YEAR(E131)+(MONTH(E131)>5),2))
kindly assist.
=IF(E131="","",YEAR(E131)-(MONTH(E131)<6)&"-"&RIGHT(YEAR(E131)+(MONTH(E131)>5),2))
kindly assist.