if function for remaining days in month

Posts: n/a

If functions for dates

Hi I need to know if anyone can give me an IF Function that will calculate
the number of days remaining in a given month. For example, if the date is
July 17th, the calculation would be 31-17+1=15 days. My problem is setting
the citeria to recognize whether the month is a 31 day month/30 day month or
28/29 day month (I would prefer not having to enter in that information for
each date). Please help! Thank you!

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode 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
Changing the range of several averaging functions	Hellion	Excel Discussion (Misc queries)	1	September 17th 05 02:12 PM
Are there functions that perform robust statistics in Excel?	froot_broot	Excel Worksheet Functions	0	August 30th 05 10:18 PM
Visible rows and functions that work	tracy	Excel Worksheet Functions	2	August 19th 05 05:25 AM
Default User Defined Functions - How?	flycast	Excel Discussion (Misc queries)	4	May 26th 05 04:26 AM
PASTE DOWN FUNCTIONS	jackle	Excel Worksheet Functions	0	May 25th 05 02:10 PM

All times are GMT +1. The time now is 10:28 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us