Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula to calucate # of months based on a speificed date entered
How can I set up a formula to determine # of months left for the year based
on the date user entered? For an example: A user enter a date on cell A1 (04/05/05) then on cell A2 will display the # of months left for the year. For this case, it will be 8. -- Thanks, David |
#2
|
|||
|
|||
Hi
=12-MONTH(A1)+1 -- Regards Frank Kabel Frankfurt, Germany "David" schrieb im Newsbeitrag ... How can I set up a formula to determine # of months left for the year based on the "date" user entered? For an example: A user enter a date on cell A1 (04/05/05) then on cell A2 will display the # of months left for the year. For this case, it will be "8". -- Thanks, David |
#3
|
|||
|
|||
One way
=DATEDIF(A2,DATE(YEAR(A2),12,31),"m") Regards, Peo Sjoblom "David" wrote: How can I set up a formula to determine # of months left for the year based on the date user entered? For an example: A user enter a date on cell A1 (04/05/05) then on cell A2 will display the # of months left for the year. For this case, it will be 8. -- Thanks, David |
#4
|
|||
|
|||
One way:
=3DDATEDIF(A1,DATE(YEAR(A1),12,31),"m") HTH Jason Atlanta, GA -----Original Message----- How can I set up a formula to determine # of months left=20 for the year based=20 on the =E2?odate=E2?=9D user entered? For an example: A user enter a date on cell A1 (04/05/05) then on cell=20 A2 will display the #=20 of months left for the year. For this case, it will be=20 =E2?o8=E2?=9D. --=20 Thanks, David . |
#5
|
|||
|
|||
Thank You!!!
"David" wrote: How can I set up a formula to determine # of months left for the year based on the date user entered? For an example: A user enter a date on cell A1 (04/05/05) then on cell A2 will display the # of months left for the year. For this case, it will be 8. -- Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
How do I add a date formula to a cell but hide the contents with . | Excel Discussion (Misc queries) | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Need to find Min value based on date range entered | Excel Worksheet Functions | |||
Need to find Min value based on date range entered | Excel Worksheet Functions |