Thread
:
DATE Functions???
View Single Post
#
3
Posted to microsoft.public.excel.programming
AA2e72E[_2_]
external usenet poster
Posts: 93
DATE Functions???
Try datediff
4-datediff("Q",firstdate,lastdayofyear
e.g
4-datediff("Q","01/09/2004","31/12/2004"
You may need to contruct lastdayofyear using "31/12/" & datepart("yyyy",firstdate
Reply With Quote
AA2e72E[_2_]
View Public Profile
Find all posts by AA2e72E[_2_]