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.