How to determine the value?
"Eric" wrote:
If today is the last day of this month, then return today+2, else today.
Does anyone have any suggestions on how to determine whether today
is the last day of this month or not?
Two ways....
=if(today()=eomonth(today(),0), 2+today(), today())
If you get a #NAME error, look at the Help page for EOMONTH for
instructions.
If you cannot or do not want to install the ATP (for Excel 2003, at least),
replace EOMONTH(TODAY(),0) with DATE(YEAR(TODAY()),1+MONTH(TODAY()),0).
Of course, you can avoid all the calls to TODAY() by putting =TODAY() into
some cell and referencing it instead in the formula above.
|