Hi
I have a question to ask.
How can I convert a week number say week 04 to a date?
If it can be done, which day (monday etc) will be reflect?
Thanks
Hi
I have a question to ask.
How can I convert a week number say week 04 to a date?
If it can be done, which day (monday etc) will be reflect?
Thanks
Re: Covert week number to actual date
if you are referring to weeknum function, you can't say its monday or friday or give you a specific date. It will only give you the range for week which starts on sunday to Saturday (its default or 1) or monday to Sunday if not the default .
Re: Covert week number to actual date
Hi
I am not referring to the weeknum function
I want to convert a date say 1 Feb 2005 to week 05.
How can I do it?
Re: Covert week number to actual date
Use weeknum function but it will give you week 6 as part is considered one whole week. Give me how you compute week 5 and i will give you the formula.
Re: Covert week number to actual date
Sorry I meant it to be the other way round -
INPUT week 05 and get a date out of it from excel.
Re: Covert week number to actual date
How do want it done? Based on Cut-off day (Saturday or Sunday) or beginning day (Sunday or Monday)?
Re: Covert week number to actual date
Assuming your year is on cell b1 and weeknum is on cell b2
Re: Covert week number to actual date
Hi
Would it affect the results? I am not too sure
Re: Covert week number to actual date
Thanks for that. I will give it a try.
Don’t have an account yet? Register yourself now and be a part of our community!