Re: $$Excel-Macros$$ Formula to Calculate Weeks

Hi Paul, is the reason one would divide by 7 is because there is 7 days in a week? Susan On Thursday, December 6, 2012 7:58:00 AM UTC-8, Paul Schreiner wrote: > > WEEKS is easy. > Keep in mind that Excel "dates" are simply numbers. > The number of days since 1/1/1900. > > You can use =TODAY() t

$$Excel-Macros$$ Request for spreadsheets that have charts using treadlines to show increase or decrease in percentag

to use as a template? I will replace with my data and send back so you can help me with the project. Many thanks in advance, Sunnie :-) -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

$$Excel-Macros$$ Re: R1C1

Yes I unchecked the box to turn off the R1C1 On Thursday, July 12, 2012 6:43:57 AM UTC-7, Sunnie wrote: > > I received a spreadsheet that is using the R1C1 reference formula. If I > turn turn off the R1C1 to apply the A1 reference will that then change how > the formula works

$$Excel-Macros$$ R1C1

I received a spreadsheet that is using the R1C1 reference formula. If I turn turn off the R1C1 to apply the A1 reference will that then change how the formula works? Thanks ! -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread title

RE: $$Excel-Macros$$ Re: Formula to add date

I need to take it a few steps further. Yes I can drag the dates down and Excel will implement next proceeding date in line. Here's the actual scenario: TOR and NOR are from my job-- word acronyms. Column AColumn B 01/01/2011 TOR (has no fill) 01/01/2011 NOR (bot