Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 1
Default calculating per quarter

I want my spreadsheet to calculate days per quarter, as in every quarter
employees are given 'x' days of vacation time. How do I do this?
  #2   Report Post  
Posted to microsoft.public.excel.newusers
external usenet poster
 
Posts: 396
Default calculating per quarter

Hi

If you put the number of the quarter in cell A1 (so 1, 2, 3 or 4), and the
year in A2, then put in:

B1: =DATE(A2,(A1-1)*3+1,1) to get the begin date of the quarter
C1: =DATE(A2,A1*3,0) to get the ending date of the quarter
D1: =C1-B1 to get the number of days in between


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"bklex" wrote:

I want my spreadsheet to calculate days per quarter, as in every quarter
employees are given 'x' days of vacation time. How do I do this?

  #3   Report Post  
Junior Member
 
Posts: 2
Smile

Works great with the following small mod:

A1: The quarter (so 1, 2, 3 or 4),
A2: The year (eg 2012),
B1: =DATE(A2,(A1-1)*3+1,1)
C1: =DATE(A2,A1*3+1,0)
D1: =C1-B1
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Calculate a quarter JPS Excel Discussion (Misc queries) 16 December 30th 08 07:19 PM
Calculate Quarter end? Gerard Excel Discussion (Misc queries) 8 June 25th 08 05:02 PM
Quarter End Date [email protected] Excel Worksheet Functions 6 April 6th 06 06:54 PM
First and Last Day of the Quarter Wolfspaw Excel Worksheet Functions 6 March 4th 06 03:10 AM
Calculating Interest where rate changes per quarter Dean Strudwick Excel Discussion (Misc queries) 1 December 7th 04 12:36 AM


All times are GMT +1. The time now is 09:01 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"