Got it........very interesting! I am probably an intermediate user.........if I do not know I can usually figure out...I do know what I do NOT know, though, and always ask for help. I am in Delaware in the US, and want to thank you again for taking the time to respond.
Thanks again!
One thing.....confused.......where did you get "1/1/03 is displayed from 37622".........do not understand where you got the 37622.
Thank you!
how can I have the current calendar year quarter automatically show from a date in a cell - not from a table? I have a 2 week pay period and need to show the current quarter that pay period is in.....so if cell L24 has "10/3/2003" for next pay date in it what formula could I use to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.