Home |
Search |
Today's Posts |
#1
|
|||
|
|||
calc constant date from variable date & return with ability to rn.
I want to calcualte in months, rounded in 1, 1.5, 2 month increments. A
constant date is being compared to varying dates, (needed to calculate sales $ based on 1 and 1.5 month increments) I used date serial numbers to determine the difference between the the two, however, converting it back to months and rounding it in 1. and .5 increments isn't working. Anyideas??? |
#2
|
|||
|
|||
Hi
and what would 0.5 month be in February or August? -- Regards Frank Kabel Frankfurt, Germany "SusieQ'sQuest" schrieb im Newsbeitrag ... I want to calcualte in months, rounded in 1, 1.5, 2 month increments. A constant date is being compared to varying dates, (needed to calculate sales $ based on 1 and 1.5 month increments) I used date serial numbers to determine the difference between the the two, however, converting it back to months and rounding it in 1. and .5 increments isn't working. Anyideas??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to return tomorrow's date. | New Users to Excel | |||
Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Return the end of month date from a date | Excel Worksheet Functions |