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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date Sum
Hi Rao,
Try: =DATE(YEAR(B10),MONTH(B10)+1,0) --- Regards, Norman "Rao Ratan Singh" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Date Sum
Not sure what you're doing with the summing of dates, but one way to
get the last day of the month: =DATE(YEAR(B10),MONTH(B10)+2,0) In XL's reckoning, the zeroth day of the month is the last day of the previous month. In article , Rao Ratan Singh wrote: 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 |
Reply |
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 |