End of the 4 quarters
Thanks Bob for looking in. The formula gave me the date of the end of the
current quarter, but how can I get this to put the value of 5 in the cell
when the actual date matches this date (3/31)? Or is there a work around by
placing the formula in a cell then referencing the result to do this?
"Bob Phillips" wrote:
=DATE(YEAR(TODAY()),(INT((MONTH(TODAY())-1)/3)+1)*3+1,0)
--
HTH
Bob Phillips
(remove nothere from the email address if mailing direct)
"ben simpson" wrote in message
...
Is there a formula that can match the end of the 4 quarters (March31,June
30,September30, and December 31) to todays date so I can initialize a
report
that is due? I'd like to have the number 5 placed in a cell to remind me.
Thank you for your help.
|