| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date question
Is there a simple formula that will give the difference between two
dates in MONTHS? Today() - (6-1-2003) = MONTHS |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date question
Try this...
A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP "Ziggy" wrote in message ... Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date question
On Apr 16, 2:44*pm, "T. Valko" wrote:
Try this... A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP "Ziggy" wrote in message ... Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS- Hide quoted text - - Show quoted text - Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date question
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Ziggy" wrote in message ... On Apr 16, 2:44 pm, "T. Valko" wrote: Try this... A1 = 6/1/2003 =DATEDIF(A1,NOW(),"m") -- Biff Microsoft Excel MVP "Ziggy" wrote in message ... Is there a simple formula that will give the difference between two dates in MONTHS? Today() - (6-1-2003) = MONTHS- Hide quoted text - - Show quoted text - Thanks it worked great. I ended up using the YEARFRAC though as a better solution for my needs, But thank you very much. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date question | Excel Discussion (Misc queries) | |||
| Date Question | Excel Worksheet Functions | |||
| DATE Question | Excel Worksheet Functions | |||
| Date Question | Excel Discussion (Misc queries) | |||
| Date Question | Excel Worksheet Functions | |||
Linear Mode
