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

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

click here to download the app (for users in the US for now) and get all the help you need.

goodluck!

Posted on Jan 02, 2017

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

This is equal to

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

If you include the end date of Jan 7, 2016 which is a Thursday, then there would be

26,294 days is equal to

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

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

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

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

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

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.

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

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.

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

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

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

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.

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

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

Jun 10, 2008 | Audiovox NVX225 Car GPS Receiver

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.

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

Jan 28, 2016 | Microsoft Excel for PC

257 people viewed this question

Usually answered in minutes!

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?

Please clarify.

×