Menu

How to calculate days in the month

Search this Thread

#1

Report Post

Posted to microsoft.public.excel.misc

Don Guillett Don Guillett is offline

Don Guillett is offline

external usenet poster

Posts: 10,124

Default

How to calculate days in the month

Both formulas test OK.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RJ Swain" wrote in message
...
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

Reply With Quote

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Calculate Number of Days in a Month	Gary T	Excel Worksheet Functions	3	November 21st 07 04:21 PM
Number of days in month counted from shortened name of month & yea	Tumar	Excel Worksheet Functions	6	September 18th 07 03:36 PM
How to calculate a date: first day of the month after 60 days	Claudia	Excel Discussion (Misc queries)	12	June 28th 07 05:10 AM
Calculate Days in a Month	LGG	Excel Discussion (Misc queries)	6	January 13th 06 06:31 PM
Calculate running target by days in the month	Robert	Excel Worksheet Functions	2	July 4th 05 06:14 AM

All times are GMT +1. The time now is 10:51 AM.

About Us

"It's about Microsoft Excel"

Contact Us ExcelBanter forum home Privacy Statement