I have a year planner in excel in which first row consist of month jan,feb.... and in the second row days are there like 1, 2,3..... and on the very first column name of employees is there so my task is to highlight weekend in the year planner for every employee

Episode # Prod # Air Date Episode Title _____ _______ _________ ___________ ______________________________________________ 1st Series 1987 1. 1- 1 6 Jan 87 The Dead of Jericho 2. 1- 2 13 Jan 87 The Silent World of Nicholas Quinn 3. 1- 3 20 Jan 87 Service of All the Dead 2nd Series 1988 4. 2- 1 25 Dec 87 The Wolvercote Tongue 5. 2- 2 8 Mar 88 Last Seen Wearing 6. 2- 3 15 Mar 88 The Settling of the Sun 7. 2- 4 22 Mar 88 Last Bus to Woodstock 3rd Series 1989 8. 3- 1 4 Jan 89 Ghost in the Machine 9. 3- 2 11 Jan 89 The Last Enemy 10. 3- 3 18 Jan 89 Deceived by Flight 11. 3- 4 25 Jan 89 The Secret of Bay 5B 4th Series 1990 12. 4- 1 3 Jan 90 The Infernal Serpent 13. 4- 2 10 Jan 90 The Sins of the Fathers 14. 4- 3 17 Jan 90 Driven to Distraction 15. 4- 4 24 Jan 90 Masonic Mysteries 5th Series 1991 16. 5- 1 20 Feb 91 Second Time Around 17. 5- 2 27 Feb 91 Fat Chance 18. 5- 3 13 Mar 91 Who Killed Harry Field? 19. 5- 4 20 Mar 91 Greeks Bearing Gifts 20. 5- 5 27 Mar 91 Promised Land, aka Inspector Morse in Australia 6th Series 1992 21. 6- 1 26 Feb 92 Dead on Time 22. 6- 2 11 Mar 92 Happy Families 23. 6- 3 25 Mar 92 The ***** of the Self 24. 6- 4 8 Apr 92 Absolute Conviction 25. 6- 5 15 Apr 92 Cherubim and Seraphim 7th Series 1993 26. 7- 1 6 Jan 93 Deadly Slumber 27. 7- 2 13 Jan 93 The Day of the Devil 28. 7- 3 20 Jan 93 Twilight of the Gods Specials 1995-2000 29. S- 1 29 Nov 95 The Way Through the Woods 30. S- 2 27 Nov 96 The Daughters of Cain 31. S- 3 19 Nov 97 ***** Is Now My Neighbour 32. S- 4 11 Nov 98 The Wench Is Dead 33. S- 5 15 Nov 00 The Remorseful Day

2B0
2 stands for factory No.2 of Exide
B stands for FEB.month like A-Jan,B-Feb,C-March.....
0 year 2010, eg: 1: 2011,2 : 2012, 9: 2009

Hello there.

You will need to write down your SERIAL number from your model/serial tag.
Example: 15114672UY...... UY is the date code. First letter is the year, second letter-month.

1980 E March
1981 G April
1982 J May
1983 L June
1984 N July
1985 P August
1986 R September
1987 T October
1988 V November
1989 X December
1990 B Jan.
1991 D Feb.
1992 F March
1993 H April
1994 K May
1995 M June
1996 Q July
1997 S Aug.
1998 U September
1999 W Oct.
2000 Y Nov.
2001 Z Dec.
2002 A Jan.
2003 C Feb.
2004 E Mar.
2005 G April
2006 J May
2007 L June

Hope that helps,


Mike

To calculate the difference in Years use =Year(c,r)-Year(c,r)
To calculate the difference in Months use =Month(c,r)-Month(c,r)
To calculate the difference in Months use =(c,r)-(c,r)

c= column, r= row

You will need to format the source cells as dates

The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

The easiest way of doing this is by inserting another row with Days
Can be MTWT etc, and you can set conditional formatting for any cell beginning with "S" into a colour/ variation of your choice.

Hi,
Cool problem I use this to track stocks for the latest 5 days, 15 days and so on.

First I have a sheet that is titled "DataRecord" this has my individual data in columns and the days recorded in rows. This is a complete record or all recorded stock activity. This is where all the entrys are made in rows. I freeze window to make the column headings and the left most column(the date) always visible to prevent errors.

Next I have a sheet that is titled "L5DaysData' I have sevreral rows of data like avg, & what ever. and the latest 5 days data starts on line say 6. a typ. cell ='DataRecord'!B970
The next cell down has a value of ='DataRecord'!B971 and so and on until B974

My Graphs are built on these individual "L5 or 15 or 60 or90 day" sheets of data.

Next I make a macro that translates the last line of data down one row and deletes the row just above the earliest that I want to save on "L5DaysData" so it always shows only the latest 5 days of information.

All the information shown on that worksheet is the data for graphs or tables refering to the latest 5 days activity.
The graphs are automatically updated with the data each time the macro is run.

You can also use a formula to adjust the date column by adding a value of one to a specfic dated cell untill you reach Sat or Sun and add 3 or 2 to that date cell and translate that down a column and use a work sheet that records only the latest 3Mo. with macros that updates the information when you want it to.
Hope this helps.
Glad to be of assistance - please rate the solution I can learn from you. Thanks

Not sure if I get your problem. Do you mean the SUM() formula with the row does not work?
That is the simplest solution if you are entering the monthly numbers per month.

If you have all these values and need to sum them up based on the current month, you need to use the MONTH() with the NOW() formulas to get a month offset and use a relative reference for the SUM() formula.

want to update maps , where do I do that and how????

Okay, here's a possible solution--based on my interpretation of your problem.

Suppose you have some value in cell B1, and the month (either Jan, Feb, or Mar) is stored in cell A1. The formula in C1, which performs calculations based on which month appears in A1, is as follows:

=IF(A1="Jan",B1*0.25,IF(A1="Feb",B1*0.3,IF(A1="Mar",B1*0.4)))

In this example, the value in B1 is multiplied by .25 if the month is Jan, by .3 if it's Feb, and .4 if it's Mar.