Thread
:
How to calculate days in the month
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett