ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Dates (https://www.excelbanter.com/excel-discussion-misc-queries/61269-re-dates.html)

Niek Otten

Dates
 
http://www.cpearson.com/excel/datetime.htm#AddingDates

--
Kind regards,

Niek Otten

"J-To" wrote in message
...
Hello. I need to set up a spreadsheet with dates. I need to have a start
date minus the current date = the time in year/month. I need to calculate
something like this, it may be easier to start with the current date and
subtract the start date.
10/01/04 - 01/01/06 = 1.4 or 01/01/06 - 10/01/04 = 1.4
Please help with any ideas, I just need a simple spreadsheet. Thanks!





All times are GMT +1. The time now is 11:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com