Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date Sum
I m using this function for Date sum =DATE (YEAR (B10), MONTH (B10) +1, 31).
This function calculates Days which we specify in this function. Is there any way that days of particular month automatically detect last day of the month? 1/1/2006 1/2/2006 Its sum should be = 3/31/2006 Thanks and Regard RRS |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
Another Date issue. | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions |