LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 159
Default filter dates by quarter

Im working on a spreadsheet for my payroll, in column
A is a weekly pay period end date
I is my gross pay for that week
Holiday pay is figured on a weekly average of the last quarter gross pay.
How do I filter the date per quarter and then average the gross for that
quarter?

 
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
Quarter Dates LR Excel Worksheet Functions 8 October 31st 06 10:27 AM
How to filter out all the partial dates from a big list of dates? Tiwarr Excel Discussion (Misc queries) 1 September 14th 06 05:35 PM
Filter dates by the day Chris AM Excel Discussion (Misc queries) 2 September 12th 06 05:16 PM
Setting quarter dates in excel RGB Excel Discussion (Misc queries) 5 May 15th 06 03:27 PM
how to filter dates? abigail New Users to Excel 2 August 18th 05 12:45 AM


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

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

About Us

"It's about Microsoft Excel"