Thread: Weekending Date w/Less Than 3 days Assoc. with Prior Month
View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default Weekending Date w/Less Than 3 days Assoc. with Prior Month
why not just
=TEXT(A1-3,"mmmm")

Yeah, that'll work.

--
Biff
Microsoft Excel MVP


"Bernd P" wrote in message
...
Hello,

Good guess, Biff, but why not just
=TEXT(A1-3,"mmmm")
then :-)

Regards,
Bernd


Reply With QuoteReply With Quote