Re: $$Excel-Macros$$ help in excel formula

2010-05-30 Thread Deepak Pal Singh
You can use =Today()-1 On Fri, May 28, 2010 at 10:07 PM, Surendra saxena surendr...@gmail.comwrote: Hi All, need you help to fix the formula in excel like below- (-Today+End.date) i want to fix the formula in excel which reflect always previous day value instead on today. -- Your's

RE: $$Excel-Macros$$ Help on excel formula

2010-02-02 Thread Dave Bonallack
I forgot to say that YEARFRAC is from the Analysis ToolPak Dave. From: davebonall...@hotmail.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Help on excel formula Date: Wed, 3 Feb 2010 13:01:33 +0800 Hi I've used the YEARFRAC funtion and multiplied it by 12. Have