Thread: help req on date
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
  
Posts: 553
Default help req on date
Why using "+1"?

"deepika :excel help" wrote:

=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