Linking computer dates (time) to spreadsheet dates that have formu

[bigisle]

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

 

[David Biddulph]

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

 

[teylyn]

Without knowing your current formulas, I can only suggest a couple o
possible approaches, for example:

If a cell should always show the 15th of the current month, use
=date(year(today()),month(today()),15)

If a given date should always be three months into the future fro
today's date, use
=date(year(today()),month(today())+3,day(today()))


hth

 

[Mike H]

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

 

[ryguy7272]

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.