Returning expected dates
Hi, I teach musical instruments. We have a grade system and it is expected that pupils reach a certain grade in a certain amount of time. By inserting the start date (mm/yy) of a pupil is it possible to generate the expected date - with reference to the report date i.e. todays date. e.g. start date of 10/03 it is expected that a pupil be at Grade 1. When I insert the start date could excel generate: Expected standard after 21 months lesson is grade 1 Oh - and I'm trying to get this to work in word - as we nned to add comment.. worth trying? Any thoughts John -- London ------------------------------------------------------------------------ London's Profile: http://www.excelforum.com/member.php...o&userid=25363 View this thread: http://www.excelforum.com/showthread...hreadid=389393 |
You'll probably be better served by posting in an MSWord newsgroup.
London wrote: Hi, I teach musical instruments. We have a grade system and it is expected that pupils reach a certain grade in a certain amount of time. By inserting the start date (mm/yy) of a pupil is it possible to generate the expected date - with reference to the report date i.e. todays date. e.g. start date of 10/03 it is expected that a pupil be at Grade 1. When I insert the start date could excel generate: Expected standard after 21 months lesson is grade 1 Oh - and I'm trying to get this to work in word - as we nned to add comment.. worth trying? Any thoughts John -- London ------------------------------------------------------------------------ London's Profile: http://www.excelforum.com/member.php...o&userid=25363 View this thread: http://www.excelforum.com/showthread...hreadid=389393 -- Dave Peterson |
All times are GMT +1. The time now is 09:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com