Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 24th 05, 06:13 AM posted to microsoft.public.excel.programming,microsoft.public.office.misc
Ed Ed is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 279
Default day of year/week of year script

Here is what I am trying to do. I am looking a way to display on the
desktop, possibly as an embeded webpage, the day of the year and the week of
the year and be able to refresh it without opening a document. For example
May 23, 2005 would be 143(day of year) and 21(week of the year). I have
found formulas for Excel to calculate the values from the computer's calendar
but I have to open the Excel file to have the information refresh. I have
also found a VB script for the current date but I am unable to get the Excel
formula to recognize the information and post the information. Does anyone
have any ideas?? The Excel formula's are :
=TEXT((A2-DATEVALUE("1/1/"&TEXT(A2,"yy"))+1),"000")
and
=TRUNC(((A2-DATE(YEAR(A2),1,0))+6)/7)
A2 is where I have the current day displaying.

  #2   Report Post  
Old May 24th 05, 11:17 AM posted to microsoft.public.excel.programming,microsoft.public.office.misc
DL DL is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 17
Default day of year/week of year script

If you are simply seeking a desktop display of this data there are numerous
apps available for this, many free.
eg PTBSync, google for this and many more

"Ed" wrote in message
...
Here is what I am trying to do. I am looking a way to display on the
desktop, possibly as an embeded webpage, the day of the year and the week

of
the year and be able to refresh it without opening a document. For

example
May 23, 2005 would be 143(day of year) and 21(week of the year). I have
found formulas for Excel to calculate the values from the computer's

calendar
but I have to open the Excel file to have the information refresh. I have
also found a VB script for the current date but I am unable to get the

Excel
formula to recognize the information and post the information. Does

anyone
have any ideas?? The Excel formula's are :
=TEXT((A2-DATEVALUE("1/1/"&TEXT(A2,"yy"))+1),"000")
and
=TRUNC(((A2-DATE(YEAR(A2),1,0))+6)/7)
A2 is where I have the current day displaying.



  #3   Report Post  
Old May 28th 05, 12:49 AM posted to microsoft.public.excel.programming,microsoft.public.office.misc
Ed Ed is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 279
Default day of year/week of year script

That was helpful. I guess what I forgot to mention is I'm looking for a
script so I don't have to cover or interrupt the regular Windows clock and
calendar. I looked at a few of the programs and they accomplished what I'm
looking for except that they took over the clock and calendar from Windows.
  #4   Report Post  
Old May 30th 05, 01:40 PM posted to microsoft.public.excel.programming,microsoft.public.office.misc
DL DL is offline
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2006
Posts: 17
Default day of year/week of year script

PTBSync has an option to display time on desktop, without
interupting/amending win tray time
Its just a matter of working through configeration to get the result you
want

"Ed" wrote in message
...
That was helpful. I guess what I forgot to mention is I'm looking for a
script so I don't have to cover or interrupt the regular Windows clock and
calendar. I looked at a few of the programs and they accomplished what

I'm
looking for except that they took over the clock and calendar from

Windows.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto calculate day of week to week of the year (not as serial) oftenconfused Excel Discussion (Misc queries) 4 June 23rd 08 05:14 PM
How do I crate a function for week of year + year in same cell. patty ann Excel Worksheet Functions 1 March 16th 08 07:34 PM
Sort by week and year Patric Excel Worksheet Functions 3 June 1st 07 02:06 AM
Sort by Year and Week Patric Excel Worksheet Functions 1 May 31st 07 11:01 PM
Week of the Year Ed Excel Discussion (Misc queries) 2 May 12th 06 10:43 PM


All times are GMT +1. The time now is 03:45 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017