tag:blogger.com,1999:blog-1119575245728734583.post5791673324964332915..comments2024-03-25T01:23:44.501+09:00Comments on Andrew's Excel Tips: Financial Date FormulasAndrewhttp://www.blogger.com/profile/09783903657254792427noreply@blogger.comBlogger5125tag:blogger.com,1999:blog-1119575245728734583.post-16438010070318426582011-09-13T06:47:02.340+09:002011-09-13T06:47:02.340+09:00Good one!Good one!Andrewhttps://www.blogger.com/profile/09783903657254792427noreply@blogger.comtag:blogger.com,1999:blog-1119575245728734583.post-15887426761187729352011-09-12T23:34:26.579+09:002011-09-12T23:34:26.579+09:00The first formula should be corrected in this way:...The first formula should be corrected in this way: YEAR(A1)-(MONTH(A1)<7) & "-" & YEAR(A1)+(MONTH(A1)>=7)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1119575245728734583.post-38422328865536712072011-09-12T06:51:00.484+09:002011-09-12T06:51:00.484+09:00Hmm, the first formula fails in the month of July....Hmm, the first formula fails in the month of July. But I like the second one :-)Andrewhttps://www.blogger.com/profile/09783903657254792427noreply@blogger.comtag:blogger.com,1999:blog-1119575245728734583.post-49784711070603377982011-09-11T20:29:05.114+09:002011-09-11T20:29:05.114+09:00=YEAR(EOMONTH(A1,-6))&"-"&YEAR(E...=YEAR(EOMONTH(A1,-6))&"-"&YEAR(EOMONTH(A1,6))Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1119575245728734583.post-8902093199787370542011-09-11T15:24:44.706+09:002011-09-11T15:24:44.706+09:00=YEAR(A1)-(MONTH(A1)<7) & "-" &am...=YEAR(A1)-(MONTH(A1)<7) & "-" & YEAR(A1)+(MONTH(A1)>7)Anonymousnoreply@blogger.com