Date calculation

  • Thread starter Thread starter Box666
  • Start date Start date
B

Box666

I have a date in cell G7 (say 21 Jun 2005), in a seperate text note I
want to say " as at the end of May 2005".

Where the date in G7 varies and the date in the text is always the
previous month.

Can any one assist please.
 
Try...

=" as at the end of "&TEXT(DATE(YEAR(G7),MONTH(G7)-1,1),"mmm yyyy")

If you want the month displayed in full, change...

"mmm yyyy"

to

"mmmm yyyy"

Hope this helps!
 
One way assuming the value in G7 is a numeric date and not text

="as at the end of "&TEXT(DATE(YEAR(G7),MONTH(G7)-1,DAY(G7)),"mmm yyyy")
 
Back
Top