Functions

date formating, creating unique calender
I need a formula that will allow me to cycle thru 10 days and back again. There are 10 levels, starting with level 1. every day that passes, the level goes up by 1, not to go over 10. So every 10 days, the cycle starts over agan. So, if something is at a level 4, and 5 days pass, the level is 9. IF its at a ... 28 Feb 2010 18:58

check if any values on row
Hi, I am trying to have a formula on cell A1 for example that would look on cells D1:CT1 to see if there are any values different than 0 (in other words not empty or equal to 0). If there are any values different than 0, cell A1 would indicate "Row with data" if none, it would say "Empty row". Any help would ... 1 Mar 2010 00:28

vlookup in aging
it's been a long day and i know this is simple to do, but i think i am burned out: =VLOOKUP(J2,{0,"0-30";30,"60";61,"120";121,"180";181,"300";241,"300";301,"365+"},2) need to be able to carry over to my pivot joe ... 1 Mar 2010 18:46

CONDITIONAL FORMATTING & NEGATIVE VALUES
I have a column D containing the names of some expenses and Income categories and I want in column F to manually enter numbers which they will become negative if the value in column D is an expense category or positive if the value in column D is an Income Category -- sato panago ... 28 Feb 2010 21:11

Friday thru Thursday
I need to pull weekly data (Friday thru Thursday) and also, create my weeks by Friday thru Thursday ... 4 Mar 2010 14:41

if worksheet protected it return "text1"
hi deares i want a formula that if worksheet protected it return "text1" and if unprotected it return "text2" in a sell.is possible? kind regards nader ... 28 Feb 2010 08:54

Excel Sheet tab names
I am making a program in excel for some time cards then workbook starts with sheet one to change the date next sheet has the list of names with all the info that needs to be put on the timesheet that lists all the names in alphabetical order and the sheet that follow are the timecards i can get it to put all t... 2 Mar 2010 14:41

Conditional Format to highlight rows
Column A is not formatted as a date but does contain the year and month as 2010 03. How can I use Conditional Formatting to highlight that row when it is the current month and current year? thanks to all... ... 28 Feb 2010 08:54

Invoice Numbers
Hi all I want to automate Invoice numbers to my spreadsheets. I have saved the file as Read Only. When I open my Excell 2003 I enter client details. I want an invoice number allocated to this client upon being saved. When I open this client file the next day to update details I don't want the Invoice num... 28 Feb 2010 07:49

protect marker
hi deares i want formula that if worksheet protected it return "text1" and if unprotected it return "text2". regard ... 28 Feb 2010 07:49