tag:blogger.com,1999:blog-1869924468172210809.post1861775047811477419..comments2024-03-22T10:09:26.517+00:00Comments on Not Just Numbers: EXCEL TIP: Making Accounting periods useful in ExcelGlen Feechanhttp://www.blogger.com/profile/12461985809302036952noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-1869924468172210809.post-55696765509985150032012-07-23T17:00:55.195+01:002012-07-23T17:00:55.195+01:00Suppose the date range is in Defined Name Ranges F...Suppose the date range is in Defined Name Ranges From and To. Suppose the dates to be tested are in column D. Define name Between=$D8=MEDIAN(From,To,$D8)<br />Then in any other column you can reference =if(Between,"do this","do that")<br />Regards<br />BrianBrianhttps://www.blogger.com/profile/06063334745698094480noreply@blogger.com