• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel date

T

tam_das

New Member
i have two dates in two different cell suppose 12/04/2012 to 11/04/2013 and i want to split this two dates in queterly order for accounting work purpose and i want result as shown below


1 qtr = 12/04/2012 to 30/06/2012

2 qtr = 01/07/2012 to 30/09/2012

3 qtr = 01/10/2012 to 31/12/2012

4 qtr = 01/01/2012 to 31/03/2013

next year = 01/04/2013 to 11/04/2013
 
Hi Das ,


If your date 12/04/2012 is named Start_Date , then the formula :


=EDATE(Start_Date,3)-DAY(EDATE(Start_Date,3))


will give the date 30/06/2012


The start of the next quarter is just this date + 1 ; the end of the next quarter is obtained by copying the above formula down.


Narayan
 
Hi, da123s!


Assuming that your starting date is in column A in cell A1, please check this formula for column B cell B1:

=FIN.MES(A1;3-RESIDUO(MES(A1);3)) -----> in english: =EOMONTH(A1,3-MOD(MONTH(A1),3))

as NARAYANK991's formula for column B works only for months N*3+1 (Jan, Apr, Jul, Oct).


Keep formula for column A cells A2 and down as suggested.


Regards!
 
I have protected my VBA project by password but i want to prevent my project such a way so that it can not be removed or cracked by the help of online available softwere
 
Hi, da123s!

I'm bad news. Any protection in Excel (open/write, workbook, worksheets and VBA project passwords) can be easily removed for a few bucks with a lot of commercial programs, for workbook & worksheets passwords only there's a free available routine and for older .xls file types there's a hex editor solution. So, you won't be able to prevent anything except from normal and not skilled users, sorry to say.

Give a look at this links:

http://chandoo.org/forums/topic/macro-to-hideunhide-in-protected-sheet-produces-error-code#post-37901

Regards!
 
   Quel doux rêve ‼


♫ Sweat dreams are made of this …


   da123s, it's like you pray Santa Claus !
 
@Marc L

Hi!

Mmais si je fais ça chaque Décembre...

Regards!

PS: But if I do that every December... (english version)
 
@Marc L

Hi!

J'habité à Paris trois mois au printemps '91 et je profité à faire un cours de plongée, il plu tous les jours.

Regards!

PS: Lived three months in the spring of '91 and I took a diving course, it rained everyday.
 
Good day Marc L


Not quite sure why you singled London out,a lot of people think it rains a lot in the UK most from the images they gather from the fertile imaginations of film directors who think that they cannot depict the UK with out it showing raining scene's. Just feel sorry for those that have to put up with all that rain in Paris :) London = 6, Paris = 10, Buenos Aires = 24 in the table


Average yearly rain fall in inches

[pre]
Code: 
1	Phoenix	        8
2	Los Angeles	13
3	Madrid	        17
4	Stockholm	20
5	San Francisco	22
6	London     	23
7	Berlin	        23
8	Bacelona	23
9	Copenhagen	23
10	Paris	        24
11	Moscow	        24
12	Frankfurt	25
13	Dublin	        30
14	Amsterdam	30
15	Toronto	        30
16	Rome	        31
17	Manchester	35
18	Chicago	        35
19	Dallas	        36
20	Kansas City	37
21	Milan	        39
22	Seattle	        40
23	Las Vegas	40
24	Buenos Aires	40
25	Zurich	        43
26	Cork	        43
27	Vancouver	44
28	Boston	        45
29	Shanghai	45
30	Brisbane	45
31	New York	46
32	Atlanta	        50
33	Tokyo	        62
35	Djakarta	63.9
36	New Orleans	64
37	Kolkutta	64.3
38	Darwin	        69.2
39	Manila	        80.7
40	Bergen	        82
41	Rabaul	        83.6
42	Mumbai	        83.8
43	Hong Kong	87.3
44	Singapore	89.5
45	Quillayute	105
46	Darjeeling	112.6
47	Suva 	        116
[/pre]
`
 
@b(ut)ob(ut)hc

Hi!

Good night, old dog.

A month ago we had at Buenos Aires (D.C.) 150 mm (60 inch) in 1 hour, and then next day in La Plata (city at 60 km from BA) 180 mm (72 inch) in 12 hours and 300 mm (120 inch in 2 days).

A whole weekend as volunteer...

Regards!
 
@SirJB7,


150mm (6 inch)

180mm (7.2 inches)

300mm (12 inches)


You will need Noah's Ark if we have your inches
 
Good morning SirJB7


I watched the news coverage on the floods, many lives lost a sad day.


http://www.bbc.co.uk/news/world-latin-america-22033533
 
@bobhc : maybe it's a national frogs' joke ! …


But my wife lived 2 years in London, I got some friends too,

and each time I took the  ♫ Last train to London, it was rainy at the end …
 
You must log in or register to reply here.
Back
Top