S
Steven
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?
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?