Help creating new functions for Excel 2013
Hi,
Am Mon, 19 Aug 2013 16:41:23 +0100 schrieb Jschock:
I tried entering the formula =IF(C2="Complete", TODAY(), "")
but that only returns me todays, date and not the date that I marked my
task as complete.
TODAY() is a volatile function and shows always today. That means the
value is changing every new day.
You have to write your date manually or with VBA.
Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|