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