Hi Excel gurus,
I'm new to the forum, so firstly Hi! I'm looking for a better solution to a problem that I have a somewhat inelegant formula for...
I'm trying to find out, for an arbitrary date, how many days have gone in the current quarter e.g. today (7th April) would return the result "7" because it's the 7th day of Q2. The solution I fudged together is...
"=TODAY()-DATE(YEAR(TODAY()),CHOOSE(ROUNDUP(MONTH(TODAY())/3,0),1,4,7,10),1)+1"
... which works but is long winded and seems a bit rubbish. Could anyone suggest improvements?
Many thanks in advance,
Dave
Bookmarks