PDA

View Full Version : Formula to Show Julian Date



rrtts
12-07-2006, 02:47 PM
I use the following formula to provide the Julian Date:
=TODAY()-DATE(YEAR(TODAY()),1,0)

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

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

I tried doing this...


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


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
12-07-2006, 03:48 PM
but it replaces the formula in the cell with these values
What do you mean by this?

rrtts
12-07-2006, 03:51 PM
When I put this in the formula bar


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


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
12-07-2006, 03:56 PM
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
12-07-2006, 04:38 PM
Weird...

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

This works...


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


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
12-07-2006, 04:43 PM
Could you post the workbook?