Hi
+$d$8 (where the date is in a date formated field)
+(g17x7) does not work.
G17 is weeks post award. 7 (days of the week) all I keep getting is value. I tried in a different cell +$d$8+14 and that failed too.
Anyone know why? I get the usual hopeless #value MS message.
Thanks