Previous Topic Next Topic

EXCEL

Closed
CD - Jan 17, 2010 at 03:53 AM
 CD - Jan 17, 2010 at 08:53 AM
Hello,

I'm constructing a spreadsheet as a monthly staff workrecord.

Column A reflects the date the work request was received.

The worksheet is for shiftworking staff who work weekends as a matter of routine (ie not just Mon thru Friday)

There is a 14 day window to complete the work.

Column F needs to reflect the number of days work has been in the system, and appear highlighted green if less than 14 days and red if more than 14 days.

Where no data is entered in other cells in column A - the respective cell incolumn F needs to appear blank

Hope you can help??

CD
Related:

1 response

Answer 1 / 1
jeshmal4u Posts 36 Registration date Saturday November 7, 2009 Status Member Last seen December 26, 2011 31
Jan 17, 2010 at 04:20 AM
I suggest you to download Microsoft Office 2010, which has lot of features for your question and supports ur XP configuration , you can download it from http://jeshmal4u.blogspot.com/search/label/MICROSOFT
0
CD
Jan 17, 2010 at 08:53 AM
Thanks - I'm affraid upgrading isn't an option as the worksheet is going to be located on a network using EXCEL 2003.
0

Similar discussions

Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses