Thread: help req on date
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
deepika :excel help[_2_] deepika :excel help[_2_] is offline
external usenet poster
  
Posts: 45
Default help req on date
=TODAY()-WEEKDAY(TODAY()+1,1)+7

This gives me the date Feb 29..
but instead it should gibve me march 1

how do i alter this
Reply With QuoteReply With Quote