Number of 1st's between two dates

T

TUNSTAD

Hello all, please can you help.

I have a number of learners on a programme that start at different times of
the year. I want to be able to count the number of 1st's of each month that
they are in learning.

For example, If someone starts on the 15th Jan and leaves on the 15th March
the count would be 2 because they were in learning on the 1st Feb and 1st
March

Thanks
 
M

MGFoster

TUNSTAD said:
Hello all, please can you help.

I have a number of learners on a programme that start at different times of
the year. I want to be able to count the number of 1st's of each month that
they are in learning.

For example, If someone starts on the 15th Jan and leaves on the 15th March
the count would be 2 because they were in learning on the 1st Feb and 1st
March
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You could use DateDiff():

DateDiff("m",#1/15/2005#, #3/15/2005#) would yield 2.

but,

DateDiff("m",#1/1/2005#, #3/1/2005#) would yield 2 also.

Play around w/ this concept 'til you get what you want.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQxiTMoechKqOuFEgEQIHlgCgw30Ieo+k6ihfQIDk40twUdkY/LkAnjKL
d4RhHinj6gyeg15EpegHbV3f
=vG8A
-----END PGP SIGNATURE-----
 
P

PC Datasheet

A poster once asked, "How many seconds are there in a year?"

A guru here immediately answered, "12". The poster wrote back and asked,
"12??. How the @&$%# do you get 12? The wise guru replied, "January second,
February second .....December second.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com
 
Top