Forum Home
Press F1
Thread ID: 49222	2004-09-13 04:20:00	Calendar / Date	willbry (1555)	Press F1

Post ID	Timestamp	Content	User
271839	2004-09-13 07:37:00	> but what if you want days earlier or the marker day is a day > different from today's date . Excel calculates dats just like any other number, either + or - Put a date in a cell . (say A1) In another cell, use arithmetic such as =A1+134, or = A1-76 As long as you format the formula cell as a date, it will display the date for the calculation . In Excel 1=1 day 1 hour = 1/24 etc .	godfather (25)
271840	2004-09-13 08:40:00	Be careful using Excel for dates. It's got a serious ;) bug in its algorithm. Try this: In a1 enter 28/2/1900 In a2 enter =a1 +1 What's the answer? The correct answer is 1/3/1900 - there was no 29 Feb in 1900, only centuries that are themselves divisible 4 by get a 29 Feb. The next one will be 2400. This may seem trivial, but by international convention the zero time for tides is 0 h 1/1/1900 GMT, so if you use Excel you'll be a day out.	TideMan (4279)
271841	2004-09-13 08:44:00	Got it! Thanks Godfather. Every possibility is now covered Appreciate everyone's contribution.	willbry (1555)
271842	2004-09-13 20:17:00	I just found out you can do it in open office, (that came on a NZ PC world CDROM a couple of months ago). oooops it's getting late for work. > In Excel you can use the following: > > In Cell A1 type =now() > this will show the current date and time. > > In the cell A2 type =A1+150 > > This will show you the current date + 150 days.... >	Earnie Moore (5918)
271843	2004-09-13 21:18:00	Instead of typing =now() in cell A1, you can type in any date you need; e.g. 31/08/2004. You can then use the = A1-150 or A1+150 in cell A2. Marlboro :-)	Marlboro (4607)
271844	2004-09-14 02:19:00	Thanks Marlboro. Godfather also led me in that direction. It's a handy tool to have at one's disposal. Tideman had an interesting alert too regarding leap years. Cheers Willbry :-)	willbry (1555)
1 2