Forum Discussion
Formatting a cell for date range
Hello all I need to format a cell so that when a date is entered that is within 12 months of today's date the cell is highlighted in green and when the date exceeds 12 months from today's date th...
Michael, is it any difference in results compare to MEDIAN?
SergeiBaklan wrote:Michael, is it any difference in results compare to MEDIAN?
Nope (maybe a "bit" shorter).
Sorry, I didn't noticed your MEDIAN suggestion nor did I get an E-Mail notifying that someone added a post in a discussion I participated.
Do you know how to switch-on the option to receive notification E-Mails ?
P.S.
Will you accept the following to be a bit more "ink saver" ?
=A1=MEDIAN(EDATE(TODAY(),{-12,12}),A1)
TXS,
Michael
Hi Michael,
Yes, with array constant it's even better.
As for the notification I'll send you in-private message shortly. No secrets, that's just off-topic for this thread.