close
www.cpearson.com/excel/datetime.htm#AddingDates
--
Kind regards,
Niek Otten
quot;J-Toquot; gt; wrote in message
...
gt; Hello. I need to set up a spreadsheet with dates. I need to have a start
gt; date minus the current date = the time in year/month. I need to calculate
gt; something like this, it may be easier to start with the current date and
gt; subtract the start date.
gt; 10/01/04 - 01/01/06 = 1.4 or 01/01/06 - 10/01/04 = 1.4
gt; Please help with any ideas, I just need a simple spreadsheet. Thanks!
全站熱搜
留言列表
