|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
September 15th, 2005, 09:32 PM
|
|||
|
|||
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. 
|
|
#2
September 15th, 2005, 09:50 PM
|
|||
|
|||
|
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.
|
|
#3
September 15th, 2005, 09:52 PM
|
|||
|
|||
|
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.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel keeps converting text to date format | John T via OfficeKB.com | General Discussion | 4 | September 12th, 2005 06:48 PM |
| Format date in excel 2000 like '31st January 2005' | Malcolm Agingwell | General Discussion | 1 | June 29th, 2005 12:01 PM |
| date format in Excel | mac@bath | General Discussion | 3 | May 15th, 2005 09:27 AM |
| Aggregating Date Data into Weeks and Quarters | Roger | Running & Setting Up Queries | 3 | July 11th, 2004 05:56 PM |
| Excel Date Field format in Mail Merge MSWord 2002 | Dick Appleby | Mailmerge | 1 | June 3rd, 2004 12:25 AM |
Linear Mode
