Re: weeknum() in reverse

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Thanks to Bob and GB for helping. I didn't realize that it would be so
complicated to go backwards or the different standards that were involved. I
have a planting calendar that hangs on my wall that is of the European
standard (didn't know it but now I do) that I use in planning crops. I also
use Excel for planning sow dates and planting dates for our greenhouse crops
and wanted the 2 to match.
Bob's forumlae puts January 6, 2008 as the first week of the year so I am
not sure what standard is applied but it is different than my wall calender
(1/1/08 is first week and 1/6/08 is the second). The formulae does the same
when GB's suggestion of replacing the Year(today()) with 2008. Is there a
change that I can make to the formulae to get it to match the wall calendar?

Thanks to both for teaching and helping me and to this group for all the
help.

"Lee" <lee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ed6zvFk1IHA.2068@xxxxxxxxxxxxxxxxxxxxxxx
Is there a way to enter the week of the year and get the date of the year?
week 2 would return January 6, 2008
week 10 would return March 2, 2008

Thanks for any help.
--
Lee Coleman




.

Relevant Pages

  • Re: Glocks new 1911
    ... # # But this thing's only relation to a standard 1911 seems to be the four ... Glock is the company that thinks a good trigger has 5.5 lb ... Win an M1 Garand from Fulton Armory while helping the Cause! ...
    (rec.guns)
  • Re: Dealing with Unreliable Serial Bus (USB NIC)
    ... > This particular box does not have standard bus extensions. ... We are helping them to ... > make use of the box with minimum cost. ... USB is slow compared to standard ethernet at ...
    (comp.os.linux.hardware)
  • Re: Datagrid not Refreshing
    ... Did you know that when you post to a newsgroup some names in code are ... standard. ... That is not with you so helping you is very difficult. ... Cor ...
    (microsoft.public.dotnet.general)
  • Re: weeknum() in reverse
    ... I have a planting calendar that hangs on my wall that is of the European ... standard that I use in planning crops. ...
    (microsoft.public.excel.newusers)