Can This Be Done?????

imported_unknown

Active Member
Joined
Jan 13, 2002
Messages
424
Is there a way to make the information on my monthly sheet understand the date? I need it to save the information on the date of the month. EX: I enter in the information on St Readings 10/02/02 which sends it to Daily, then to monthly. Now I have 10/03/02 information to put in. Is there any way to make Monthly understand the date and information to show up on the right line?
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

texasalynn

Well-known Member
Joined
May 19, 2002
Messages
8,458
I'm not sure I completely understand your issue but to be the month of a cell use:

=MONTH(A1)

Where A1 has your date
10/3/02


HTH
texasalynn
 

s-o-s

Active Member
Joined
Apr 14, 2002
Messages
384
I read this differently,

On the monthly sheet you can use the SUMIF function to pickup dates that match a specific date.

Your daily database has a date field in column A, and a value in column B.

Your monthly sheet has a line for each date where date appears as column A also.

in Column B you can Enter

=SUMIF(Daily!A1:A50,A5,Daily!B1:B50)

This above eg will search through all lines in Daily row 1-50 for a date that matches the Monthly Cell A5 and sums all matching values from column B.



_________________
Hope This Helps.
Sean.<A HREF= "http://website.lineone.net/~s-o-s/Index.html">
image001.gif

Win98, XL2000
This message was edited by s-o-s on 2002-10-07 08:39
 

Forum statistics

Threads
1,144,208
Messages
5,723,022
Members
422,476
Latest member
beck85

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top