| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
rounding a month upwards , after using an =datedif fomula
I use formula to calculate numbe rof elapsed months between 2 dates..
=datedif(a1,b1,"m").... but then want to round up to 1 month, in case the time elapsed is actually less than 1 month within the =dated calcs. Anyhelp please? Thank you. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rounding a month upwards , after using an =datedif fomula
Maybe
=MAX(1,DATEDIF(A1,B1,"m")) Mike "spudsnruf" wrote: I use formula to calculate numbe rof elapsed months between 2 dates.. =datedif(a1,b1,"m").... but then want to round up to 1 month, in case the time elapsed is actually less than 1 month within the =dated calcs. Anyhelp please? Thank you. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rounding a month upwards , after using an =datedif fomula
Thats spot on!. Thank you..dont suppose you can solve my other problem
....(cant blame me for trying!) I have an =sumif formula, which I am trying to total 2 criteria... 1 is if payment was from a given customer...which i can do... but then to also only add that payment from the given customer if payment was received before a given date?. Thanks v much anyway. "Mike H" wrote: Maybe =MAX(1,DATEDIF(A1,B1,"m")) Mike "spudsnruf" wrote: I use formula to calculate numbe rof elapsed months between 2 dates.. =datedif(a1,b1,"m").... but then want to round up to 1 month, in case the time elapsed is actually less than 1 month within the =dated calcs. Anyhelp please? Thank you. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
rounding a month upwards , after using an =datedif fomula
Hi
Try =SUMPRODUCT(($A$2:$A$100="CustomerA")*($B$2:$B$100 <DATE(2008,2,19)) where Column A contains Customers and column B contains Dates. Change ranges to suit Change comparison's to cell values if required -- Regards Roger Govier "spudsnruf" wrote in message ... Thats spot on!. Thank you..dont suppose you can solve my other problem ...(cant blame me for trying!) I have an =sumif formula, which I am trying to total 2 criteria... 1 is if payment was from a given customer...which i can do... but then to also only add that payment from the given customer if payment was received before a given date?. Thanks v much anyway. "Mike H" wrote: Maybe =MAX(1,DATEDIF(A1,B1,"m")) Mike "spudsnruf" wrote: I use formula to calculate numbe rof elapsed months between 2 dates.. =datedif(a1,b1,"m").... but then want to round up to 1 month, in case the time elapsed is actually less than 1 month within the =dated calcs. Anyhelp please? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Fomula for number of days on each month from a date range | Excel Discussion (Misc queries) | |||
| Month (datedif) to 1 decimal | Excel Worksheet Functions | |||
| Datedif incorrect month count - February problem?? | Excel Worksheet Functions | |||
| rounding the DATEDIF function | Excel Discussion (Misc queries) | |||
| DATEDIF calculates a month off | New Users to Excel | |||
Linear Mode
