Aloha I am hoping someone is out there who can assist me. I have spent two
days trying to do two simple things in a medicine sheet I made up. It
involves the dates. They need to change by the month, we have figured out the
formulas that in itself was difficult. But NOW HOW do I TIE IN my computers
Calendar (where the time clock) is TO the dates I have in the spreadsheet?
So when the computer calendar changes the spreadsheet dates change per the
formula that is in there?
THank you very much Antoinette

We probably need a bit more information on what you are trying to do, but
=TODAY() will give the current date.
--
David Biddulph

"bigisle" wrote in message
...
Aloha I am hoping someone is out there who can assist me. I have spent two
days trying to do two simple things in a medicine sheet I made up. It
involves the dates. They need to change by the month, we have figured out
the
formulas that in itself was difficult. But NOW HOW do I TIE IN my
computers
Calendar (where the time clock) is TO the dates I have in the spreadsheet?
So when the computer calendar changes the spreadsheet dates change per the
formula that is in there?
THank you very much Antoinette

Hi,

This relies on your dates being properly formatted dates. So with the date
in column A we can sum column B for Jan 2010

=SUMPRODUCT(--(TEXT(A1:A10,"mmm/yy")="Jan/10"),B1:B10)

and if we need another criteria such as a person or company name we can
expand that to

=SUMPRODUCT(--(TEXT(A1:A10,"mmm/yy")="Jan/10"),--(C1:C10="Some
person"),B1:B10)

You can of course swap the columns as required.

Mike

"bigisle" wrote:

Aloha I am hoping someone is out there who can assist me. I have spent two
days trying to do two simple things in a medicine sheet I made up. It
involves the dates. They need to change by the month, we have figured out the
formulas that in itself was difficult. But NOW HOW do I TIE IN my computers
Calendar (where the time clock) is TO the dates I have in the spreadsheet?
So when the computer calendar changes the spreadsheet dates change per the
formula that is in there?
THank you very much Antoinette

Dang, there's many ways you can go with this:

Look at this:
http://www.fontstuff.com/excel/exltut02.htm

Or, this:
http://www.techonthenet.com/excel/formulas/today.php

Or, this:
http://www.techonthenet.com/excel/formulas/now.php

If you need more, post back with more details.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"bigisle" wrote:

Aloha I am hoping someone is out there who can assist me. I have spent two
days trying to do two simple things in a medicine sheet I made up. It
involves the dates. They need to change by the month, we have figured out the
formulas that in itself was difficult. But NOW HOW do I TIE IN my computers
Calendar (where the time clock) is TO the dates I have in the spreadsheet?
So when the computer calendar changes the spreadsheet dates change per the
formula that is in there?
THank you very much Antoinette