This does work as needed, I was just looking for a way to shorten the formula, or not use an IF formula. I am pretty new to the advanced formulas and VBA, and everything I have learned has been from...
Type: Posts; User: steve400243
This does work as needed, I was just looking for a way to shorten the formula, or not use an IF formula. I am pretty new to the advanced formulas and VBA, and everything I have learned has been from...
Thanks for looking at this Admin - My apologies for not explaining what I was looking for better - Maybe this will help. I appreciate your time.
starting in B3 is the completed date, then in
...
Hello, I was hoping you can look at this post?
http://www.excelfox.com/forum/forumdisplay.php/2-Excel-Help
Hello, I use this formula to group data on a pivot table by our Fiscal year, could it be shorter?
=IF(MONTH([@[Comp Date]])=1,[@Year]&"-Q3",IF(OR(MONTH([@[Comp Date]])=3,MONTH([@[Comp...