Refer the attach file of VBA codes.
Can it be complete from the total nos.of Quarter between 2 dates?
Suppose,one is 22/05/2013 and other is 05/02/2014,then,total no.of Quarter should be "4".
The following criteria should be apply:-
Jan~Mar
Apr~Jun
Jul~Sep
Oct~Dec
If any date falls between one range ,it should count 1 quarter.
Adding the Total nos.of Quarter between 2 dates
-
RENU1973
- Lounger
- Posts: 26
- Joined: 20 Jan 2014, 11:18
- Location: nepal
Adding the Total nos.of Quarter between 2 dates
You do not have the required permissions to view the files attached to this post.
-
StuartR
- Administrator
- Posts: 12612
- Joined: 16 Jan 2010, 15:49
- Location: London, Europe
Re: Adding the Total nos.of Quarter between 2 dates
This same question has been asked in the Excel forum
Please post any responses there, I have locked this thread to prevent replies being split between two threads.
Please post any responses there, I have locked this thread to prevent replies being split between two threads.
StuartR