If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Linking computer dates (time) to spreadsheet dates that have formu
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 |
#2
|
|||
|
|||
Linking computer dates (time) to spreadsheet dates that have formu
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 |
#3
|
|||
|
|||
Linking computer dates (time) to spreadsheet dates that have formu
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 |
#4
|
|||
|
|||
Linking computer dates (time) to spreadsheet dates that have formu
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 |
Thread Tools | |
Display Modes | |
|
|