Formula to Show Julian Date

[rrtts]

I use the following formula to provide the Julian Date:
[VBA]=TODAY()-DATE(YEAR(TODAY()),1,0)[/VBA]

So, for today...it results in 341.

I'm trying to modify it to show 341 / 342.

I tried doing this...

[VBA]
=TODAY()-DATE(YEAR(TODAY()),1,0) & " / " & TODAY()-DATE(YEAR(TODAY()),1,0)+1
[/VBA]

Which gives me 341 / 342 but it replaces the formula in the cell with these values...I want the formula to remain so it will update whenever I open the sheet.

I'm sure I'm doing something wrong...anybody have an idea?

[mdmackillop]

but it replaces the formula in the cell with these values

What do you mean by this?

[rrtts]

When I put this in the formula bar

[VBA]
=TODAY()-DATE(YEAR(TODAY()),1,0) & " / " & TODAY()-DATE(YEAR(TODAY()),1,0)+1
[/VBA]

As soon as I hit the enter key the cell displays 341 / 342

And if you click the cell...thats what shows in the formula bar...the formula is gone. Hope that helps clear it up.

[mdmackillop]

It clarifies your problem, but I don't understand it. Does it do the same for eg =A1+B1? This "functionality" could be achieved by code. Is there anything in the Worksheet or Workbook module that could cause this? Can you post the workbook?
Regards
MD

[rrtts]

Weird...

In a blank worksheet (which I should've tried before posting...doh!)

This works...

[VBA]
=TODAY()-DATE(YEAR(TODAY()),1,0)&" / "&TODAY()-DATE(YEAR(TODAY()),1,0)+1
[/VBA]

But when I post in my project...it switches as mentioned in my initial post...It has to be some kind of setting or something...

[malik641]

Could you post the workbook?