Question about Microsoft Excel for PC

# Highlight weekend in the year planner

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

Posted by on

• Jim Kirk May 11, 2010

Does the second row start columns dated 1-31 for each month? You would have January and below it in a column you would have 1-31?

×

• Level 2:

An expert who has achieved level 2 by getting 100 points

All-Star:

An expert that got 10 achievements.

MVP:

An expert that got 5 achievements.

Vice President:

An expert whose answer got voted for 100 times.

• Expert

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.

Posted on May 22, 2009

Hi,
A 6ya expert can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
The service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
Good luck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### How many days from 01/11/1944 to 01/07/2016

Date difference from Jan 11, 1944 to Jan 7, 2016 The total number of days between Tuesday, January 11th, 1944 and Thursday, January 7th, 2016 is 26,294 days.
This is equal to 71 years, 11 months, and 27 days.
This does not include the end date, so it's accurate if you're measuring your age in days, or the total days between the start and end date. But if you want the duration of an event that includes both the starting date and the ending date, then it would actually be 26,295 days.
If you're counting workdays or weekends, there are 18,782 weekdays and 7,512 weekend days.
If you include the end date of Jan 7, 2016 which is a Thursday, then there would be 18,783 weekdays and 7,512 weekend days including both the starting Tuesday and the ending Thursday.
26,294 days is equal to 3,756 weeks and 2 days.
The total time span from 1944-01-11 to 2016-01-07 is 631,056 hours.
This is equivalent to 37,863,360 minutes.
You can also convert 26,294 days to 2,271,801,600 seconds.

Number of days between January 11th 1944 and January 7th 2016

Jan 10, 2017 | Watches

### I wabt to know the titles of Inspector morse books in order

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

May 07, 2015 | Miscellaneous

### Hello, i am trying to find out when the MDE6400AYA was made.. What year

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

Jul 27, 2011 | Maytag Atlantis MDE7400AY Electric Dryer

### How to calculate the difference of two dates by year, month and day using the formula in excel?

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

Mar 15, 2009 | Microsoft Office Excel 2003 for PC

### 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...

There is always multiple solutions, but here is one...

Add a row (that can be hidden later if you want) where you have the full date (01/01/09). For this example it will be row "C." Then use Conditional Formatting with the function:

=weekday(C\$2,2)>5.

See if this helps.

Jan 03, 2009 | Microsoft Excel for PC

### To highligh weekend in the year planner

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.

Jan 03, 2009 | Microsoft Excel for PC

### Excel support

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

Oct 24, 2008 | Microsoft Office 2003 Basic Edition...

### Horizontal

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.

Jun 23, 2008 | Microsoft Excel for PC

### Jensen nvx200

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

Jun 10, 2008 | Audiovox NVX225 Car GPS Receiver

### Multiple arguments in excel

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.

Nov 09, 2007 | Computers & Internet

#### Related Topics:

258 people viewed this question

Level 3 Expert

Level 3 Expert