View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
nibbana nibbana is offline
external usenet poster
 
Posts: 8
Default Another date formula

Here's my data:

A B
1 1-Jun-08 1-Jul-08
2 30-Jun-08 31-Jul-08

I need a formula in B1 and B2 that will:

If col A date is first day of month then return first day of next month; or
If col A date is last day of month then return last day of next month.

Thanks!