ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Returning expected dates (https://www.excelbanter.com/excel-worksheet-functions/36659-returning-expected-dates.html)

London

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


Dave Peterson

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