Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Questions
I have a comparison report I must do every week that need the below periods.
I would like for my Queries to calulate these dates automatically without me having to enter the specific date ranges. The periods are as follows: - Two weeks prior to this week. Depending when I do this report weather it is Monday or Tuesday the information is for the 2 full work weeks (Sunday through the 2nd Saturday) prior to this week, not two weeks prior to Monday or Tuesday . So if I do the report ths week the information should be from Sunday 1-7-07 to the 2nd Saturday 1-20-07. How do I write an expression to give me the information for the the two work weeks prior to this week regardless of when I do the report? - Two week period prior to the one above, for the report I do this week the period would be from Sunday 12-24-06 to Saturday 1-6-07. How do I write an expression that would give me this periods information? - Year to date for current year - Year to date for perivious year Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Questions
Dan,
With the date in A2 Start date: =A2-WEEKDAY(A2)+1-14 or A2-WEEKDAY(A2)-13 End date: =A2-WEEKDAY(A2) -- Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- "Dan" wrote in message ... I have a comparison report I must do every week that need the below periods. I would like for my Queries to calulate these dates automatically without me having to enter the specific date ranges. The periods are as follows: - Two weeks prior to this week. Depending when I do this report weather it is Monday or Tuesday the information is for the 2 full work weeks (Sunday through the 2nd Saturday) prior to this week, not two weeks prior to Monday or Tuesday . So if I do the report ths week the information should be from Sunday 1-7-07 to the 2nd Saturday 1-20-07. How do I write an expression to give me the information for the the two work weeks prior to this week regardless of when I do the report? - Two week period prior to the one above, for the report I do this week the period would be from Sunday 12-24-06 to Saturday 1-6-07. How do I write an expression that would give me this periods information? - Year to date for current year - Year to date for perivious year Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of occurences on a particular date | Excel Worksheet Functions | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
Date Format Questions | Excel Discussion (Misc queries) |