Excel - Help Please

mercman1969

I am at a complete loss as to IF i can achieve what i wish to and would appreciate some help / direction

I have a datum cell

From that datum cell, i have a number of cells that i would like to auto populate from the datum cell

Trouble is some of the cells require a period of days, whilst others only require working days (mon / fri).....

I expect that it cant be achieved due to the 2 variables, but wondered if it could be done linked to a calendar somehow

The table is to remind / prompt me of deadlines following an inspection

I need to carry some things out after a period say of 28 days - to include weekends, whilst others need to be done after 10 working days - mon to fri only


Thanks

somethingcorporate

There is both a day and workday function within excel so I am sure you could put these to some use.

I am not sure specifically what you are trying to do but excel works on a sequential numbers for dates so today is 41335 (the number excel has chosen to give today and tomorrow will be 41336.

mercman1969

Its to do with carry out an inspection

Prior to the inspection date (say 1st May 2013) I have stuff that requires differing deadlines

i have to provide a plan of the inspection within 28 calendar days of the inspection

Once the inspection has been completed, i have to produce a document within 10 working days of the inspection

so inputing things manually for single items isnt a problem, but keeping track of many is a problem, particulary when the inspection date may be moved

so as the inspection scheduled for 1st May 2013 goes

I have to provide a plan of the inspection by Wednesday 3rd april (28 calendar days)

I have to produce the report by Weds 15th May (10 working days)....

I am VERY new to excel so am lost already by your initial reply

Thanks

rmg1

Let's say you have your inspection date in cell A2, in cell B2 you could have =A2+28 (which would give you your 28 calendar days).
In cell C2 you would have =workday(A2,10). This would give you your 10 working days after the date in cell A2.

mercman1969

For the 28 day item, it needs to be prior to the inspection date

Would i be correct to assume its simply a case of A2-28


Many thanks.....very kind and much appreciated

mercman1969

The calendar formula i can get to work

I cant get the workday to populate

I click into the cell and then select the autosum button

It brings up "=SUM"

How do i get the workday formula to work please

mercman1969

oK.......

Getting there, slowly

I am using 05-May-13 as my cell C8

I wish to obtain a date for 9 working days after this

I have entered =WORKDAY(C8,9) into the cell i require the date to show

The result i get from this formula is 41410

how do i get the formula to show as a date field


Regards

Valli

In the cell displaying 41410 right click
select format cell from the drop-down menu
click on the NUMBER tab
scroll down to date
select date and choose style of date from RHS of dialogue box
Click OK