Thread: Date Question
View Single Post
  #7   Report Post  
Old October 29th 04, 06:56 AM
G
 
Posts: n/a
Default

Thanks Frank,

I actually worked it out about 3 minutes after posting my reply.. my fault i
am a novice when it comes to date functions..

I don't suppose there is an easy way to work the same equasion out but for
last calander week ??

Again Thanks

"Frank Kabel" wrote:

Hi
typo on my side. Try:
=DATE(YEAR(NOW()),MONTH(NOW()),0)

--
Regards
Frank Kabel
Frankfurt, Germany

"G" schrieb im Newsbeitrag
news
Thanks Frank ,

I am having a little trouble with the second formula (b2)..

Any thoughts

"Frank Kabel" wrote:

Hi
try:
B1:
=DATE(YEAR(NOW()),MONTH(NOW())-1,1)

B2:
=DATE(YEAR(NOW(),MONTH(NOW()),0)

--
Regards
Frank Kabel
Frankfurt, Germany

"G" schrieb im Newsbeitrag
...
I have an Excel SS that has a summary page that has several count

if
/ sum if
values. Many of which refer to date ranges. today etc.

Is it possible for me to capture all data in a range of the last
calander
month ie. if i all dates in October.

Currently i have the formulas written to count details within the
last 31
days however i would like to make this a little more correct.

example :
=SUMPRODUCT((whoC="gn") * (typec="email " ) * (whenb<B1) * (

whenb
B2) )

B1 = Now()
B2 = B1 - 31

Any help very much appreciated