End of Last Year Date Formula.

[GreenyMcDuff]

Hi all,

I need a formula that will always display 31/12/previous year

So in the cell at the moment we would have 31/12/2010
On the first of January next year, the cell would then change to display 31/12/2011.

Seems like it should be simple enough, but I can't figure it out.

Thanks

Chris

 

[Aladin Akyurek]

Hi all,

I need a formula that will always display 31/12/previous year

So in the cell at the moment we would have 31/12/2010
On the first of January next year, the cell would then change to display 31/12/2011.

Seems like it should be simple enough, but I can't figure it out.

Thanks

Chris

Try...

=DATE(YEAR(TODAY())-1,12,31)

 

[GreenyMcDuff]

Works a treat. Thanks

 

[T. Valko]

Hi all,

I need a formula that will always display 31/12/previous year

So in the cell at the moment we would have 31/12/2010
On the first of January next year, the cell would then change to display 31/12/2011.

Seems like it should be simple enough, but I can't figure it out.

Thanks

Chris

Here's another one that's a few keystrokes shorter...

=DATE(YEAR(NOW()),1,0)

 

[Aladin Akyurek]

Works a treat. Thanks

You are welcome. Thanks for providing feedback.