Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Issue
Hi all,
I use this formula to pull specific rows out of a master sheet and sum their totals. In this instance, all rows for the month of January: =SUMPRODUCT(--('Daily Reading Master Log'!B3:B400=DATEVALUE("01/01")),--('Daily Reading Master Log'!B3:B400<=DATEVALUE("30/01")),'Daily Reading Master Log'!BU3:BU400) Question: How can i make the date more generic so i will not have to update the formula each year? I would like the formula to look for the month and day only...and not worry about the year because only one year of data will be held in the workbook. Ideas? -- Carlee |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Issue
Hi Calee,
DATEVALUE("01/01") and DATEVALUE("30/01") will always return dates in the current year --- Regards, Norman "Carlee" wrote in message ... Hi all, I use this formula to pull specific rows out of a master sheet and sum their totals. In this instance, all rows for the month of January: =SUMPRODUCT(--('Daily Reading Master Log'!B3:B400=DATEVALUE("01/01")),--('Daily Reading Master Log'!B3:B400<='Daily Reading Master Log'!BU3:BU400) Question: How can i make the date more generic so i will not have to update the formula each year? I would like the formula to look for the month and day only...and not worry about the year because only one year of data will be held in the workbook. Ideas? -- Carlee |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Issue | Excel Discussion (Misc queries) | |||
Date issue | Excel Discussion (Misc queries) | |||
DATE ISSUE! | Excel Worksheet Functions | |||
Date issue | Excel Worksheet Functions | |||
date issue | Excel Programming |