Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition of Days
I've have a formula that calculates, from a date entry, the number of
days elapsed in that month. E.g. An entry of "20/12/09" will return "20" With this NG's assistance, I achieve this with =R6-DATE(MONTH(R6),1,0) in cell T6. Q. How do I convert the result in T6 to a numeric. I want to add the days remaining in the month (in cell T6) to a number elsewhere? At the moment I'm adding a date serial number to a numeric giving a stupid result. Tks - Ricky |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition of Days
Use this instead
=DAY(R6) and format as general -- __________________________________ HTH Bob "Ricky" wrote in message ... I've have a formula that calculates, from a date entry, the number of days elapsed in that month. E.g. An entry of "20/12/09" will return "20" With this NG's assistance, I achieve this with =R6-DATE(MONTH(R6),1,0) in cell T6. Q. How do I convert the result in T6 to a numeric. I want to add the days remaining in the month (in cell T6) to a number elsewhere? At the moment I'm adding a date serial number to a numeric giving a stupid result. Tks - Ricky |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition of Days
Great! Thanks Bob.
Ricky Bob Phillips wrote: Use this instead =DAY(R6) and format as general |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Addition of Days
Date serial numbers are numeric, so you can add one to the other, but I
think you must have misread the advice given on this NG. Your formula would give 20/12/1997, or 35784 as a number, as your DATE function is giving 12 years (the value of MONTH(R6) in the year field of the DATE function) as the amount to subtract. The formula you would need is =R6-DATE(YEAR(R6),MONTH(R6),0) If you format that as General or Number it will show 20. The DAY() suggestion in another reply is of course easier. -- David Biddulph "Ricky" wrote in message ... I've have a formula that calculates, from a date entry, the number of days elapsed in that month. E.g. An entry of "20/12/09" will return "20" With this NG's assistance, I achieve this with =R6-DATE(MONTH(R6),1,0) in cell T6. Q. How do I convert the result in T6 to a numeric. I want to add the days remaining in the month (in cell T6) to a number elsewhere? At the moment I'm adding a date serial number to a numeric giving a stupid result. Tks - Ricky |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Employee days worked (-Holidays, -weekends, Snow Days, etc) | Excel Discussion (Misc queries) | |||
Calc days between two dates and exclude leap year days | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made | Excel Worksheet Functions | |||
row addition | Excel Worksheet Functions |