Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate days in the month
Good Afternoon,
I have a simple question, at least I hope it is. I am working on a spreadsheet where I have 3 columns (C2,D2,E2) that represent the date for 3 months in a quarter. What I would like to be able to do is have cell F2 count the days for the month(s). Example: C2 D2 E2 F2 1-31-08 02-15-08 ---- 46 One twist is the dates will change from week to week as this is worksheet has figures that are updated weekly and the days on the quarter are needed for another calculation. Thank you |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate days in the month
in f2
=MAX(C2:E2)-DATEVALUE("12/31/2007") -- Don Guillett Microsoft MVP Excel SalesAid Software "RJ Swain" wrote in message ... Good Afternoon, I have a simple question, at least I hope it is. I am working on a spreadsheet where I have 3 columns (C2,D2,E2) that represent the date for 3 months in a quarter. What I would like to be able to do is have cell F2 count the days for the month(s). Example: C2 D2 E2 F2 1-31-08 02-15-08 ---- 46 One twist is the dates will change from week to week as this is worksheet has figures that are updated weekly and the days on the quarter are needed for another calculation. Thank you |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate days in the month
AH HA! Thank you so much! i just had to change the cell to number and I got it!
"Don Guillett" wrote: in f2 =MAX(C2:E2)-DATEVALUE("12/31/2007") -- Don Guillett Microsoft MVP Excel SalesAid Software "RJ Swain" wrote in message ... Good Afternoon, I have a simple question, at least I hope it is. I am working on a spreadsheet where I have 3 columns (C2,D2,E2) that represent the date for 3 months in a quarter. What I would like to be able to do is have cell F2 count the days for the month(s). Example: C2 D2 E2 F2 1-31-08 02-15-08 ---- 46 One twist is the dates will change from week to week as this is worksheet has figures that are updated weekly and the days on the quarter are needed for another calculation. Thank you |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate days in the month
You haven't stated what dates are in the cells. If they are the month end
date(s), or the current date, perhaps =DAY(C2)+DAY(D2)+DAY(E2) would work. In your example, that formula would produce 46. Perhaps you could give more details. Tyro "RJ Swain" wrote in message ... Good Afternoon, I have a simple question, at least I hope it is. I am working on a spreadsheet where I have 3 columns (C2,D2,E2) that represent the date for 3 months in a quarter. What I would like to be able to do is have cell F2 count the days for the month(s). Example: C2 D2 E2 F2 1-31-08 02-15-08 ---- 46 One twist is the dates will change from week to week as this is worksheet has figures that are updated weekly and the days on the quarter are needed for another calculation. Thank you |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate days in the month
Well, the example is C2 is month end but the number will change through the
month as in example D2. So the following week, D2 will show 02-22-08 and so on. "Tyro" wrote: You haven't stated what dates are in the cells. If they are the month end date(s), or the current date, perhaps =DAY(C2)+DAY(D2)+DAY(E2) would work. In your example, that formula would produce 46. Perhaps you could give more details. Tyro "RJ Swain" wrote in message ... Good Afternoon, I have a simple question, at least I hope it is. I am working on a spreadsheet where I have 3 columns (C2,D2,E2) that represent the date for 3 months in a quarter. What I would like to be able to do is have cell F2 count the days for the month(s). Example: C2 D2 E2 F2 1-31-08 02-15-08 ---- 46 One twist is the dates will change from week to week as this is worksheet has figures that are updated weekly and the days on the quarter are needed for another calculation. Thank you |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to calculate days in the month
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculate Number of Days in a Month | Excel Worksheet Functions | |||
Number of days in month counted from shortened name of month & yea | Excel Worksheet Functions | |||
How to calculate a date: first day of the month after 60 days | Excel Discussion (Misc queries) | |||
Calculate Days in a Month | Excel Discussion (Misc queries) | |||
Calculate running target by days in the month | Excel Worksheet Functions |