| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date - Date = x Days formula
Good morning all,
I have a spreadsheet with a list of days. And i would like to create a formula so it reads something like. Today (read off the computer or manually typed in) - 31/01/06 = 28 Is this at all possible? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date - Date = x Days formula
i have tried using the
=today() function but it doesnt seem to work as intended in the help file :/ "Ernest Lai" wrote: Good morning all, I have a spreadsheet with a list of days. And i would like to create a formula so it reads something like. Today (read off the computer or manually typed in) - 31/01/06 = 28 Is this at all possible? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date - Date = x Days formula
Put your date in A1 and =today() in B1 and =DATEDIF(A1,B1,"d") in C1
-- Gary's Student "Ernest Lai" wrote: Good morning all, I have a spreadsheet with a list of days. And i would like to create a formula so it reads something like. Today (read off the computer or manually typed in) - 31/01/06 = 28 Is this at all possible? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date - Date = x Days formula
Hi Ernest
=TODAY()-"31/01/06" You need to format the cell with the formula as General, then it will show 28. It will probably be showing 28/01/1900, as it will have picked up a date format. -- Regards Roger Govier "Ernest Lai" wrote in message ... i have tried using the =today() function but it doesnt seem to work as intended in the help file :/ "Ernest Lai" wrote: Good morning all, I have a spreadsheet with a list of days. And i would like to create a formula so it reads something like. Today (read off the computer or manually typed in) - 31/01/06 = 28 Is this at all possible? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Date - Date = x Days formula
O LOL - i really need to wake up. That was perfect thanks. I actually went
and changed the format of the cell so it would get rid of the time 00:00. thanks a lot for the replies :D "Roger Govier" wrote: Hi Ernest =TODAY()-"31/01/06" You need to format the cell with the formula as General, then it will show 28. It will probably be showing 28/01/1900, as it will have picked up a date format. -- Regards Roger Govier "Ernest Lai" wrote in message ... i have tried using the =today() function but it doesnt seem to work as intended in the help file :/ "Ernest Lai" wrote: Good morning all, I have a spreadsheet with a list of days. And i would like to create a formula so it reads something like. Today (read off the computer or manually typed in) - 31/01/06 = 28 Is this at all possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to calculate number of days & ignore blank cells | Excel Discussion (Misc queries) | |||
| Adding XY days to date in cells | Excel Discussion (Misc queries) | |||
| Year-to-date year to date formula | Excel Worksheet Functions | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Networkdays | Excel Worksheet Functions | |||
Linear Mode
