One way

a bit of a workaround

=COUNT(B1:B12)*30-15
format the cell as custom......... mmm

--
Greetings from New Zealand
Bill K

"Ruff" wrote in message
...
I setup a worksheet like below

A B
1 Jan 123
2 Feb 543
3 Mar 654
4 Apr 456
5 May 645
6 Jun 543
7 Jul 0
8 Aug 0
9 Sep 0
10 Oct 0
11 Nov 0
12 Dec 0
13

When the end of the month, the user will enter some value in the B column,
And now I would to setup a formula at A13, if the user enter the value in
the B7, then the A13 will show Jul, when the user carry on to enter the
value in the B8, then the A13 will change to show Aug, is it possible to
setup a if formula or other formula rather than use the macro to doing
this?
Many Thanks.

Ruff