plz help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have a column containing different dates of a year. i want if the specified
date is greater than 7th of the month it should return me (in another column)
the 22nd day of next month,otherwise it should show me 7th day of next month.
 
What do you mean by "the month"?. Is it current month or value from th
column? You can enter formula to column where you want the result to b
written. Below is an example of the formula.

This assuming your date column is in A. Change the column to sui
yours. Don't forget to set your result column to date format (othe
wise it'll only shows some numbers).

=IF(DAY(A1)>7,DATE(YEAR(A1),MONTH(A1)+1,DAY(22)),DATE(YEAR(A1),MONTH(A1)+1,DAY(7)))

Best regards
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Function for Anniversary Dates 5
excel date problem 3
Excel Vba to change displayed year automatically. 14
Average cells 3
Rounding date field up to next first of month, with existing formu 5
Date 2
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Days Count Sheet Help 5

Back
Top