Help WTD please with dates
 

Can anybody help me with a dilemma I have in excel. It all revolves around
calendar dates, dates from and dates to and dates in between.

What I am trying to do is construct a spreadsheet which will show me a date
in the future from a date I have entered.

For example:

I want to put a date in say cell A1 (Date of Commencement of work) and from
this date a set of rules will apply.

I want to enter a date in cell A2 (first day of sickness) and from this date
be able to use a chart to determine how much sick pay an employee is
eligible for.

The rules of sick pay entitlement are time based (the longer the service the
more time allowed off sick etc)

If anyone could point me in the right direction re formulas etc I would be
most grateful.

I think that the DATEDIFF function may come into play here?

Help WTD please with dates
 

Steven

When you know how dates and times work in excel it is fairly simple and you
generally need little more the simple arithmetic and formatting.

You can learn about it here

www.cpearson.com/excel/datetime.htm

--

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
web: www.nickhodge.co.uk
blog (non tech): www.nickhodge.co.uk/blog


"Steven" wrote in message
...
Can anybody help me with a dilemma I have in excel. It all revolves around
calendar dates, dates from and dates to and dates in between.

What I am trying to do is construct a spreadsheet which will show me a
date in the future from a date I have entered.

For example:

I want to put a date in say cell A1 (Date of Commencement of work) and
from this date a set of rules will apply.

I want to enter a date in cell A2 (first day of sickness) and from this
date be able to use a chart to determine how much sick pay an employee is
eligible for.

The rules of sick pay entitlement are time based (the longer the service
the more time allowed off sick etc)

If anyone could point me in the right direction re formulas etc I would be
most grateful.

I think that the DATEDIFF function may come into play here?