Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help needed on Date formulas
Hi, I need to keep track of weekly bug counts on a periodic basis.Here is an example Date logged P1 bugs P2 bugs Week Logged(Sunday) [To be calculated using formula] 01/02/2006 2 3 01/0/12006 01/05/2006 3 5 01/01/2006 01/10/2006 5 5 01/10/2006 In Excel,I would like to find out using formulas, the exact bug counts for each week,by manipulating the date logged.Irrespective of any date it was logged,there should be a column which contains the formula,to find the week in which the bug was logged.Is it possible in Excel ? Please help. Shantha -- shminas ------------------------------------------------------------------------ shminas's Profile: http://www.excelforum.com/member.php...o&userid=33981 View this thread: http://www.excelforum.com/showthread...hreadid=537530 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Help needed on Date formulas
This formula always returns the previous Sunday (or on a Sunday that day's date) for a date in A1 =A1+1-WEEKDAY(A1) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=537530 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas based on a date | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Excel date formulas | Excel Discussion (Misc queries) | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |