format date in excel
 

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.

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.

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.