Date Questions

[Dan]

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

 

[Earl Kiosterud]

Dan,

With the date in A2
Start date: =A2-WEEKDAY(A2)+1-14 or A2-WEEKDAY(A2)-13
End date: =A2-WEEKDAY(A2)