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

  • Thread starter Thread starter bigisle
  • Start date Start date
B

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
 
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
 
Back
Top