| Forum Home | ||||
| Press F1 | ||||
| Thread ID: 49222 | 2004-09-13 04:20:00 | Calendar / Date | willbry (1555) | Press F1 |
| Post ID | Timestamp | Content | User | ||
| 271829 | 2004-09-13 04:20:00 | Is there a facility on my PC I can access that will tell me the date say 150 or any no. of days ahead from today. or any date marker I specify. I have W98SE and Office 97 and have tried the Help function in both but no joy. Thanks guys | willbry (1555) | ||
| 271830 | 2004-09-13 04:30:00 | Outlook might have this facility. Under the date thing in 98 ( I think there's one). You can go ahead so many days, dont think u can mark a date. Unless u get a shareware program that does the same thing.. | Spacemannz (808) | ||
| 271831 | 2004-09-13 04:39:00 | Thunderbird, the email client companion to Firefox, has a nice calendar and scheduler extension you can do that in. Thunderbird (www.mozilla.org) TBird Extensions (update.mozilla.org) Cheers Murray P |
Murray P (44) | ||
| 271832 | 2004-09-13 04:55:00 | > Is there a facility on my PC I can access that will > tell me the date say 150 or any no. of days ahead > from today. or any date marker I specify. I have > W98SE and Office 97 and have tried the Help function > in both but no joy. Thanks guys As you have Office 97 you probably have Excel. If so then put todays date in cell A1 being formatted as a date cell. Hilight the complete column and format the complete column as date format. In A1 you will have 13/09/2004 for today for example. Select cells a1 to a150 (or whatever) and fill the series down. Step 1 by day. Not the most elegant of solutions but it will work. Just checked and 150 days from today gives me Wed 9 Feb 2005 |
Elephant (599) | ||
| 271833 | 2004-09-13 05:11:00 | 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.... |
Marlboro (4607) | ||
| 271834 | 2004-09-13 06:01:00 | Thanks so much to you all for your solutions. I've actually used yours Marlboro as it seems the simplest as it takes all of 5 seconds to implement and it works. By the way Elephant, are you positive that +150 days is 9th Feb? According to Marlboro's formula it should be 29th Feb. Again my appreciation to all you guys. What a great forum. | willbry (1555) | ||
| 271835 | 2004-09-13 06:33:00 | . By the way Elephant, are you positive > that +150 days is 9th Feb? According to Marlboro's > formula it should be 29th Feb . Again my appreciation > to all you guys . What a great forum . Not 100% positive here . I did not actually count 150 days from today on a calender . What I did was to put a date in cell a1 . Scrolled down 150 rows from 13/9/2004 and read the value in cell 150 after filling with step 1 series . I thought I could be off by one day . |
Elephant (599) | ||
| 271836 | 2004-09-13 06:42:00 | I have to add that your original question any date marker lead me in a different direction. Is this the start date which is always the date today or may the start date be a date in the future or even in the past + 150 days? Or plus 30 days etc. |
Elephant (599) | ||
| 271837 | 2004-09-13 07:18:00 | I owe you an apology Elephant. I must have got it wrong as it can't be 29 Feb [ not a leap year]. I did it again using Marlborio's formula and got 10th Feb. Marlboro's solution is quick for a specified number of days ahead of the current date but what if you want days earlier or the marker day is a day different from today's date. I wonder if Marlboro has a formular Using Excel for these situations? | willbry (1555) | ||
| 271838 | 2004-09-13 07:27:00 | No real apology needed. Wait until Parry gets into the act. |
Elephant (599) | ||
| 1 2 | |||||