Thread: Rounding Dates to the 1st?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
wdjsxj
 
Posts: n/a
Default Rounding Dates to the 1st?
=date(year(a1),month(a1),1)

€œlawdoggy€ç¼–写：

Hello,

How do I round any date to the first of that month?

Example: Jan 25 == Jan 01
Dec 14 == Dec 01

Any Help is appreciated. thanks.........mitch


Reply With QuoteReply With Quote