oops - that was backwards:
=(if(day(today())=A2,B2,"")
"Duke Carey" wrote:
in the To Date column - assume it is C2
=(if(day(today())<=A2,B2,"")
"Nigel" wrote:
hi,
Can you format a date in a formula to recognise the date only? i have a
column with the day number only and need to calculate the figure directly to
the right as this day number reaches todays date.
example:
day cost to date
12 £60.00
if todays date was 11th september, to date would be empty but if todays date
was 12th september, to date would have the figure £60.00 in it.
thanks in advance,
N.S.
|