$$Excel-Macros$$ Re: Calculate workdays between 2 dates

2008-10-08 Thread AJIT NAVRE
Oh! I forgot the Workday() function. THanks for reminding Ajit On Tue, Oct 7, 2008 at 8:03 PM, Ajay Varshney <[EMAIL PROTECTED]>wrote: > Check the formula from attached file. > > You should use Workday formula > > Regards, > Ajay Varshney > > On Tue, Oct 7, 2008 at 12:45 AM, sanj <[EMAIL PROT

$$Excel-Macros$$ Re: HOW TO CALCUATE THE NO. OF YEARS BETWEEN TWO DATES

2008-10-08 Thread H Upadhyay
pls chk formula in atached file Thanks & Regards Harish Upadhyay On 10/6/08, Augustine <[EMAIL PROTECTED]> wrote: > > Hi everybody, > >I tried using the DateDif function in Ms-Office 2007 but its not > working. Is there any other way to activate the function since i heard that > the functi

$$Excel-Macros$$ How to run the macro only if data available else stop.

2008-10-08 Thread Mayank Patel
Dear friends, I need ur help in macro I have created one macro in my Daily sales tracker file to update my report. I use to paste one report at the bottom of the file which has 6 columns and there are 6 more columns which require to be updated manually by using vlookups (column head are like Categ

$$Excel-Macros$$ Re: Page numbering in excel

2008-10-08 Thread H Upadhyay
try this & confirm File - Print Preview - Setup - HEader/Footer - Custom Footer - Select The ICON( #) rightside to format text Thanx & regards Harish Upadhyay 9773284902 On 9/30/08, vivek jain <[EMAIL PROTECTED]> wrote: > > Thanks for the reply. > > But this method does not update page numbers