Re: Dispaly Sum if a cell is filled in
Or something like this:
=IF(A1="","",(TODAY()-A1)/365.26)
Posts by 2rrs
-
-
give data>text to columns a try. this usually works for me
-
If the formula solution does not suit; you can go to tools>options>calculation and check the manual box.
This will display the results in the status bar. -
Try this:
SUBTOTAL(3,A1:A500)
-
Custom format; 00000
-
Here is a rather simple method:
Filter the list on FG
On the 1st FG item; chg to FG 0001
Drag and fill down the filtered list.
Unfilter the list and you will have a sequentialy numbered list -
In sheet 2
Select the cell where you want the data to appear.
Now select sheet 1
Now select the cell in sheet 1 that you want to appear in sheet 2
Hit enter.
-
Hi ecggt,
Sorry but I don't understand what you mean by "no frame".
I tested it and Brandtrock's formula with a series of 24 different dates and both returned the same results.
I did have to add "Friday and Saturday" to Brandtrock's formula which I copied and pasted from the post. -
Or maybe this;
=TEXT(A1,"dddd")
fill down -
Tools
options
view
row and column headers -
Try this:
Assumes due date is in col C2:C100
and # of days in col D2:D100In a cell off to the side of your data; say H1, enter =TODAY()
In D2 enter: C2-$H$1 and copy down; this returns the number of days between the current date and the date in col C
Conditional format col D for >14 days
2rrs
-
also have a look here:http://myweb.cableone.net/twodays/
-
Give this a try:
In B54 enter =SUM(OFFSET(B46,0,0):OFFSET(B46,-12,0)) Drag across to I54
In B55 enter =SUM(OFFSET(B46,0,0):OFFSET(B46,-24,0)) Drag across to I55
In B56 enter =SUM(OFFSET(B46,0,0):OFFSET(B46,-36,0)) Drag across to I56
-
[quote]Originally posted by dbin78
Thank You,What would it be to use a date in a cell?
If i enter any given date and want to add three months.
Cell A1 = 02/02/03
Cell A2 = A1+3 months????Thanks [/quote
Try this:
=EDATE(A1,3)
-
QuoteDisplay More
Originally posted by daveray
Okay, the formula that Will gave doesn't appear to work because the cell references are wrong. It looks like something I could understand if I could see it working for real.I have attached an actual portion of my sheet and the cell references are identical.
If you could rewrite the formula with Month, today etc all contained in one cell that would be great.
The formula that Neale listed seems to work but if I am honest I cannot understand it and could therefore never replicate it in a real life scenario - hope that makes sense ??
Many thanks
Dave
Give this a try:
=AVERAGE(OFFSET(B9,0,0,1,MONTH(NOW())))
2rrs
-
Hi excelnewbie,
I also thought of a pivot table but did not think that the layout would support it.
Two things you mentioned suggest a more basic solution may be considered.
a) You have a large spreadsheet; this would make the task of changing the layout to support use of a pivot table difficult;
b) You state that the purpose for the summary is to print a sheet to put in a folder.The sample layout that you provided shows data for two stores; if you want to print the data for one store only; you could select all data for 'store number 5211"; then go to file, print, and check "selection".then OK.
This will print only store 5211 data.
Do this for each 'store number"I hope I did not misunderstand the purpose of your post.
2rrs
-
Hi,
here are several sites that have good help on this subject2rrs
http://www.ozgrid.com/Excel/ExcelDateandTimes.htm
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/overtime.htm
http://j-walk.com/ss/excel/files/timesht.htm -
Sorry,
gave cpearson site twice, should have been:http://www.mvps.org/dmcritchie/excel/datetime.htm
2rrs
-
Quote
Originally posted by Mamamech
Is it possible to calculate these parameters:
Time In
Time Out
Less time out for lunch
Then display results in hours and tenths of hours?Hi, take a look at these sites; they give a excellent timesheet overview and each has a sample download file.
2rrs
http://www.cpearson.com/excel/overtime.htm
http://www.cpearson.com/excel/overtime.htm
-
QuoteDisplay More
Originally posted by Neale
Hi 2rrstry this
open a new workbook
enter Jul02 thru to jun03 in a range
right click toolbar select Forms
click combobox draw the box
ensure control tab is visible
select the range with the dates in the input range box
and select cell for the output range
click ok close forms toolbar
have fun
HTHHi Neale,
It didn't take long for me to run into trouble!
I got as far as drawing the combo box; then found that my control tab was "gray", I tried to figure it out with no luck.
I did find this on Google MS excell public forum:
"Quote"
Ken Anderson wrote: > Hi, I am trying to create a drop down combo box in excel > 2000. I create the box and then right click over the top > of it and select 'Format Control'. At that point I'm > suppose to be able to go to the 'Control' tab and give it > the input range. However, the control tab isn't > there. 'Size, Protection, Properties and Web' tabs are > there, but no Control tab. If I go to a spreadsheet that > already has a drop down box created on it, and i right > click and goto the Format Control..it has a Control tab. > But there isn't one when I try to create it from scratch."Response"
The existing combo boxes are from the Forms toolbar, and you're using the combo box from the Control Toolbox. To set the properties for your combo box, select the combo box, and click the Properties button on the control toolbox. You can set the ListFillRange (like Input range), LinkedCell, and ListRows properties.
-- Debra Dalgleish Excel FAQ, Tips & Book List
___________________________________I attempted to follow the directions, but I am lost.
Help please, 2rrs