Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
date calculation
If I have 2 date columns how do I create a formula to subtrack? example:
(b4) November 30, 2007 and (c4) November 6, 1986. My formula is: =month(b4)-month(c4) in column D, but I get 0 and I have formatted the column to numbers. I also did =month(c4)-month(b4). Is there another way to this to get the correct #? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Tricky Date calculation: How to calculate a future date | Excel Discussion (Misc queries) | |||
Date calculation | Excel Worksheet Functions | |||
Date Calculation | Excel Discussion (Misc queries) | |||
Date calculation | Excel Worksheet Functions | |||
date calculation | Excel Worksheet Functions |